By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Is It Possible to Prevent Access Updating if the user has entered data via a Form

P: 2
I am interested in preventing Access Updating if the User Has inadvertently entered wrong information via a Form. Is it possible to flag up a message "Do You Really Want to Do This prior to the update?

TIA
Colin
Nov 26 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
YEAH IT IS POSSIBLE!

USE BEFORE UPDATE EVENT PROCEDURE!

There yout ype an inputbox that asks your question

like code should be:

Expand|Select|Wrap|Line Numbers
  1. If Me.NewRecord = False Then
  2.     i = MsgBox("Do you want to change the value of your key?", vbYesNo + vbCritical + vbDefaultButton2, "Change key")
  3. 'Stop
  4.         If i = vbNo Then
  5.             Cancel = True
  6.             Me!Key_element.Undo
  7.         Else
  8.             Cancel = False
  9.         End If
  10. End If
  11.  
  12.  
Nov 26 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.