G
Guest
I created a simple form in Access 2003. How do I force Access to prompt me
before updating a record?
before updating a record?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
In the form's BeforeUpdate event, put the following code:
If MsgBox("Save the current record?", vbOkCancel, "Confirm Save") = vbCancel
Then
Cancel = True
EndIf
Barry
If MsgBox("Save the current record?", vbOkCancel, "Confirm Save") = vbCancel
Then
Cancel = True
EndIf
Barry
G
Guest
Worked perfectly. Thanks.
M
MaCh
Hi
I have same problem with updating records. I put the code in BEFORE
UPDATE EVENT and the only change is it doesn't update anything, even if
we enter new data in new form.
How do I solve this.
Thanks
MaCh
I have same problem with updating records. I put the code in BEFORE
UPDATE EVENT and the only change is it doesn't update anything, even if
we enter new data in new form.
How do I solve this.
Thanks
MaCh