Setting focus

[Pat]

When you set the focus to a control on a tab in a form, do you have to set the focus to the tab first?

[HansV]

No, setting focus to a control on a tab page will automatically activate that tab page.

[Pat]

I should have told more of the story, i get an error message on a setfocus command that i cannot set the focus to that control.
What are the conditions that a setfocus cannot work. I have a msgbox a few coomands after that setfocus command so i am not in VBA at the time it bombs.

[HansV]

Does the error message mention why you can't set focus to it?
Is the control on a subform? If so, you must first set focus to the subform.
Is the control hidden at the moment that you want to set focus to it? If so, you must first make the control visible.

[Pat]

I'll check that.