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?

 

[Keith Wilby]

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?

Easiest way is probably to have a button run an update query and then to
requery the form.

Keith.
www.keithwilby.com