Is there a simple way to code the exit button to ask if you want to save the information only if there were changes done to the fields?
Is there a simple way to code the exit button to ask if you want to save the information only if there were changes done to the fields?
the system saves when you exit the record.
nothing to do.
Not the way I have it set up. In this particular instance I found it best to use unbound fields and save them to bound fields when I exit. They load up when the form is brought up. I've used this method before and just compared fields. If there were changes, it saved the information. This has too many fields to do that though. Normally I don't do this, but sometimes it's the best way.
You would need to set a flag on the form to true based on any updates to any fields.
On Exit check the flag and either save or don't.
It's messy with loads of fields, better to use the forms before update event and a bound form.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓