Basic Question Save (Commit) record

[mous]

Very basic question coming up ...

Does anyone know how to Save the current record on a form using Visual basic.

I have an update query that will not work from a button on this form until I save this record. Currently, I have to move to a different record and back again and then run the query.

Thanks

 

[ghudson]

Try this...

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdSaveRecord


HTH

 

[mous]

Brilliant. Thank you.

Dawn