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

[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?

 

[Rick B]

If Me.Dirty Then 'Save any edits.

Me.Dirty = False

End If

 

[Judy Ward]

This is what I would use in the button click event on the main form:

DoCmd.RunCommand acCmdSaveRecord

 

[Joe Clark]

If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If

DoCmd.RunCommand acCmdSaveRecord

Ooh, two very different methods. Isn't Access cool?