DoMenuItem for adding a record

[Fredrated]

What is the DoMenuItem command to add a record to the table a form is using
as a recordsource?

Thanks

Fred

 

[Allen Browne]

To take the user to a new record so they can enter it:
RunCommand acCmdRecordsGotoNew

To actually add a new record, use AddNew and Update on the RecordsetClone of
the form. Then set the form's Bookmark to the clone set's. (This approach
has the advantage of not having to Requery the form to discover the new
record.)