macro go to a new subform record

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top