Create a macro to go to a field within a subform

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
that would make sense,

thanks

Ken Snell (MVP) said:
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.
Click to expand...
 
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?
 
I've worked it out.

I just used "gotorecord" and left it blank except chose "new" in the record
option.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Use Macro to Filter records in Subform on open 0
Adding a record to a subform with a macro 2
Populate a field on a subform from data in a pop-up modal form 4
Set focus using macro? 4
going to last record in subform 1
go to control error message 1
How do I filter data on a subform using a macro? 0

Back
Top