I have a single table app with a form. The form pretty much just displays the data that is in the table in a more user friendly view. Right now when a user enters data into the form it automatically adds it to the table. What I want is for the table to not be updated until the user clicks a Save button. Can anyone tell me how to do this?
Table Locking
- Thread starter arstacey
- Start date
RuralGuy
AWF VIP
- Local time
- Today, 05:21
- Joined
- Jul 2, 2005
- Messages
- 13,819
The easiest method is to check a flag in the BeforeUpdate event of the form and not allow updates unless the flag has been reset by your "Save" button. You should probably provide an escape method with Me.UnDo if the user wants to bail out.
Sorry but I am a noob when it comes to access. All I have ever used it for was storing data in a table. This is my first form. How do I check a flag in teh beforeupdate event? Do I do this on each field or once for the entire form?
RuralGuy
AWF VIP
- Local time
- Today, 05:21
- Joined
- Jul 2, 2005
- Messages
- 13,819
It seems to me that ghudson's better mouse trap should provide some ideas and probably solutions to your issue.
Sorry but I am a noob when it comes to access. All I have ever used it for was storing data in a table. This is my first form. How do I check a flag in teh beforeupdate event? Do I do this on each field or once for the entire form?
