Hello All,
I have a form that I allow additions on.
From the very beginning, I have been able to use the record navigation buttons on the bottom left to go to the end of the recordset, go one beyond and type stuff (where a new record is automatically inserted).
Then, to "save" this record, the only way I discovered was to use the record navigatino buttons again to move to another record, then move back to verify it was added.
So what I'm looking for, here, is a way to programmatically "save" the inserted record without having to navigate to another record. I've tried using the "RecordSet.Update" method, but it complains about there not being a previous "AddNew" or "Edit".
I cannot turn off "AllowAdditions" on the form for reasons I won't go into here.
Anyone give me a clue?

Thanks,
-Mike

Add a command button and use RunCommand acCmdSaveRecord on the On Click event.

HTH,

Beth