update

[Rose Collins]

I have a database that I am trying to do an update. I want Me.Diff =
Me.CurrentCount - Me.Standard. I only want to update this once, so
on_current wont work. Is there a way to make a button work for all records
on the form?

 

[Guest]

When posting a question, it is most helpful to add your operating system and
version of Access. Try this: (Works for Access 2002.)

Make an update query, enter your update formula. On your form, with the
Wizard selected, add a command button. Under Categories, select
Miscellaneous; under Actions, select Run Query. Select your update query and
finish the instructions of the Wizard.