Activate Subform

[TimTDP]

I have a main form containing a subform.
I use the command
Forms!frmMainForm.Form!frmSubForm!Id.SetFocus to move to the Id field in the subform.
However the main form remains the active form.

How can I make the sub form the active form?
I need to do this because I want to create a recordset on the subform.

Thanks in advance

 

[RoyVidar]

It should probably be

[tt]Forms!frmMainForm!frmSubForm.Form!Id.SetFocus[/tt]

but, I think you'll also need to setfocus to the subform itself

[tt]Forms!frmMainForm!frmSubForm.SetFocus[/tt]

- and be carefull not to use the same names on form controls, as the fields they are bound to, it may come back an bite you...

Roy-Vidar

 

[TimTDP]

Hi Roy-Vidar

Thanks for the reply, but it did not help.
Thanks

 

[RoyVidar]

How sad...

Roy-Vidar