need a line of code to commit the new record to the table

  • Thread starter Thread starter Joe Clark
  • Start date Start date
J

Joe Clark

I'm working on a form that has a button leading the user to a related
form, and I get an error if somebody begins a new record on the parent
form, then clicks the link to go to the child form *before* the new
record has been committed to the table (before data entry is complete,
i.e. when the pencil is still visible in the record selector area).
What's the command to "finish" the record?
 
This is what I would use in the button click event on the main form:

DoCmd.RunCommand acCmdSaveRecord
 
Back
Top