macro go to a new subform record

G

Guest

I have a subform which allows user data entry. I'm trying to add a record to
the subform, but it always goes into the first record, even if data has
already been entered. When I try to use the Go To Record command in the
macro, I get an error message that the form is not open. The notation I'm
using is
Forms![mainform]![subformControlName].Form
and I'm running Access 97
 
S

Steve Schapel

Bob,

Where is this macro being activated from? If it's from somewhere within
the subform, then I think it will work to leave the Object Type and
Object Name arguments blank. If it's from somewhere within the main
form, I think you will need to use a GoToControl action in the macro
before the GoToRecord action, to move the focus to the subform first.
 

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

Adding a record to a subform with a macro 2
Access Automatically Send a notification email once a record is added 0
Open subform to specific record 2
setvalue action changes record focus 5
Requery Subform 4
Access Main form/Subform Navigation 0
going to last record in subform 1
Use macro to add new linked record ACC07 8

Top