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

Why not have a button that turns "Allow Additions" to true, based on the user keing in a password. Thus you have the best of both words, security and access.

John

Mike,

On your form's design view, make sure the Wizards button is toggled ON an then put a new command button on your form. That will activate the Wizard. It will guide you into putting a button on the form that will save the data. When you do that and view the code behind it, you should see something like this on the button's ON CLICK event:

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

You could try adding a button called 'Save this Record' to the form and set an On_click event for it with this coding:

DoCmd.RunCommand acCmdSaveRecord

which runs the menu command 'Save Record.

Hope this helps

Cheers Ray