Create a macro to go to a field within a subform

[scubadiver]

How do I do this?

 

[Ken Snell \(MVP\)]

You need two sequential GoToControl actions. The first one uses the name of
the subform control (the control that holds the subform object). The second
one uses the name of the control on the subform.

 

[scubadiver]

that would make sense,

thanks

You need two sequential GoToControl actions. The first one uses the name of
the subform control (the control that holds the subform object). The second
one uses the name of the control on the subform.

 

[scubadiver]

I've done that and a step further by sorting the records. Now I have done
that I would like to send the cursor to the last record.

The only option I have in the macro is "department subform". When I run the
macro, it says 'The object "Department subform" isn't open'.

Any idea?

 

[scubadiver]

I've worked it out.

I just used "gotorecord" and left it blank except chose "new" in the record
option.