How can i focus a field in a subform ?

[Guest]

Hi,

In the main form i have a tab control which includes a sub form.
My question is that how can I focus on a field from the main form to the
subform which is in the tab control ?

 

[Allen Browne]

Each form has an ActiveControl. You need to make the subform control on the
main form the active control, and then specify which control in the subform
is the active control there.

Try something like this:

Me.[NameOfYourSubformControl].SetFocus
Me.[NameOfYourSubformControl].Form![NameOfControlInSubform].SetFocus