Setting Focus on a sub Form

[CLOS]

I have a form with a sub-form that I need to set focus on the fields within the sub-form. How do I set this up? I don't have a problem doing it on the main
form, but I need to do it on the sub-form. Help! Help! Help! , Thanks.

 

[pjm]

CLOS

You need something like:

Forms!myFormName!mySubFormName!mySubFormControl.SetFocus

pjm

 

[binky]

I have used...
me.childform.form!field_Name.setfocus

That may work as well.

HTH
Ken

 

[Lightning]

You might find that you need to set the focus explicitly to the subform first, then set the focus to the desired control.

MyForm!Subform.SetFocus
MyForm!Subform!MyControl.SetFocus

You could also use the ME keyword:

Me!Subform.SetFocus
Me!Subform!MyControl.SetFocus


HTH

Lightning