Jan 16 2004, 11:30 AM
Users on a simple application are mistakenly overwriting data on the forms. I need to adjust the form to not update the fields or records until the user OKs the changes. Could someone point me in the general direction.
Jan 16 2004, 11:35 AM
You can check the Dirty property in the forms Before Update event to see if the user made a change. If the did then notify them and then let them continue (save the changes) or exit without saving. With the cursor in the Before Update event and clicking F1 will tell you how this event works and will give you a code example or two...
Jan 16 2004, 11:42 AM
I counld not find a Dirty property for the form. I am in Access 97, is this a property that is available in this version? Maybe I'm not looking in the right place...
Jan 16 2004, 11:50 AM
In the Before Update event of the form you want to use code something like this:
If Me.Dirty Then
...data has changed do let the user know and let them choose what to do
Jan 16 2004, 11:53 AM
I understand now... many thanks!
Jan 16 2004, 12:04 PM
You are welcome and good luck. If you hit a wall just post a new question and someone will be able to assist you.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here