Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Force record lock using yes/no box

Status
Not open for further replies.

rmyslik

IS-IT--Management
Aug 2, 2001
33
US
I have read some threads and thought I had it. I want to lock records AFTER the box is marked or clicked. Here is what I have where record completed is the name if the yes/no box. I had added an automatic date afteupdate and it worked very well. However this just doesn't lock the record?

I used this in forms On Current Event:
If Me![record_completed]= true then
Me.AllowEdits=True
Else
Me.AllowEdits=False
End if.
 
OK well I answered my own question. I just had some syntax mixed up. But how do I enable this for editing if needed without going into the programming area? Is there a similar routine to "unlock" for editing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top