Lock record if field is "Yes"

jimjaix

Registered User.
Local time
Yesterday, 20:43
Joined
Dec 12, 2007
Messages
20
Hi, I have a form for user to input data. And also have a field called "Complete?" I want create some vba code that will lock that record IF the field Complete? is a Yes. And then give a message.
 
Use the current event of the form, test the value of that field with an If/Then/Else, and set AllowEdits to True or False appropriately.
 
Can you give me an example? I am new to access and not sure how things work.
 
Disregard my previous message, the name didn't match. Changed the name and it works
 
Try

If Me.Completed = True Then
 

Users who are viewing this thread

Back
Top Bottom