Conditional Locking?

[wcrc]

I would like to use one text box to determine whether or not to lock a data entry box.

e.g. If [Equip_status] = "in work" then unlock [start_date]

I know that there has to be a way, I just can make it work.


Thanks in advance

 

[Rob.Mills]

Run this procedure in the form's On Current event:

If [Equip_status] = "in work" then
me![start_date].Locked=True
End if

 

[wcrc]

Thank you immensely! I was racking my head for that one.

 

[wcrc]

Thank you immensely! I was racking my head for that one.