Changing from form to subform???

[Kieran]

I have a form with a subform. I want to use a macro to go from a control in the main form to a control in the subform.

I use GoToControl, but it just says that there is no field with that name. I wouldn't even mind if i could just set focus to the subform...

Please help with some suggestions.....


Thanks

 

[Fizzio]

Set the focus to the subform first, then set the focus to the control. The VBA to do this is

Me.NameofSubform.SetFocus 
Me.NameofSubform.Form!NameofControl.SetFocus

 

[Kieran]

macro

is there anyway i can do it using a macro??

 

[Kieran]

Did it....

I used the GoToControl command and pointed it to the subform first.

Thanks for the help, pointed me in the right direction.