GoToControl to a subform

[Chris M.]

I am trying to have a macro move focus from the main form
to a subform using the GoToControl action in a macro.
Access help says the syntax should be:

Forms![mainformname]![subformname].form

I've tried every conceivable combination of syntax and it
continues to give me the error "field not found on current
record"

I do not want to code an event procedure, but only want to
use macros and their associated actions and arguments.

Any help?

 

[Ken Snell]

Use two consecutive GoToControl actions. The first one to set focus on the
subform control (the one that holds the subform). The second to set focus to
a control on that subform.