Saving a record programmatically

[davesmith202]

I have a form with a command button that runs a couple of update queries. But before these queries are run, I would like to save the current record. These queries will be using the data the current record and so it needs saving.

How do I save the record programmatically?

Thanks,

Dave

 

[The_Doc_Man]

Use the button query wizard to build yourself a button using the wizard's Record Save option. Then look at the code it built to see how you do that from some other button.

 

[boblarson]

Just add

If Me.Dirty Then Me.Dirty = False

to the button's code before it runs anything.

 

[davesmith202]

Great recommendations. Thank you!