Full Version: Disable/Lock Field After Update
UtterAccess Forums > Microsoft® Access > Access Forms
Philly
Hello All-
He have a form with "Date Completed" and "Completed By" fields. After data is put into these fields,we don't want people to be able to change this information. Can someone explain how this can be coded? Thanks for the assistance!
Philly
AQM_UK
Well set the control property to enabled = False and Locked = true
e.MyDate.Enabled=false
Me.CompletedBy.Locked=True
HTH
Jim
kbrewster
You could put the following code on the forms Current event.
e.[Date Completed].Locked= Len(Me.[Date Completed] & vbNullString) <> 0
Do the same thing for the CompletedBy...just change the name of the control
Philly
THANKS GUYS FOR THE QUICK AND EXPERT ASSISTANCE!
hilly
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.