2 subforms and gotocontrol

[Gavin]

Hi i have a form that contains two subforms. I have a
macro attached to one field on subform1 which if a
particular option is chosen i want to go to a new record
in subform2.

I have set an if statement, this all works fine, my
trouble is when trying to get the focus out of one subform
and into another. I tried simply GoToControl in the macro
and naming subform2, but it says that the form is not
open! i then tried setting the focus on an object on the
main form, and then setting the focus on subform2 but this
still didnt work..

Hope this makes sense. Any ideas would be much
appreciated. Thanks

Gavin

 

[Ken Snell]

Macros will not allow you to set focus onto a second-level subform. You'll
need to use VBA code to do that instead. If you can provide more info about
when you want to have the focus set to the second subform, we can provide
some ideas for you.