Prompt before updating a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a simple form in Access 2003. How do I force Access to prompt me
before updating a record?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for records 2
Separate Form 0
Filling in fields to a partially complete record in a table using a form 0
Need help on VBA excel macro and API to close an external application 0
Going to first record 0
HELP - I have a question about saving a form 9
DMax on existing record to increment serialized # fails 1
How to UPDATE records using a sub-form 1

Back
Top