Locking control after value is changed from it's default value

[baadams]

I want to lock a control after it's been changed from it's default value. Not allowing any additional changes unless a password is supplied. Locking or password protecting the control will work. Is there a way to check the value when the control has focus to check for the default value, then prompt for a password if the value does not equal the default value? I can handle the code to prompt for the password, I'm curious as to what event to use.

 

[baadams]

I figured it out..........

I used the Got Focus event to perform the following.


If not(isnull(me.field)) then
msg = MsgBox("This field can't be changed from it's original value", vOKOnly)
field2.SetFocus
End If

So once the value has been input it can't be changed. I haven't added the password code to set the focus back to the selected field if a change is allowed.
This solution just sees the value isn't null and changes the focus to a different field so the user doesn't have the chance to make any changes. I didn't need to set a default value.