Locked fields

[AshleyJohn]

I would like a paticular field to be locked once the user has entered data and moved to the next field, but I would only want this field to be lock on that paticular record so the field needs to be unlocked for other records to be entered. Also I will need a way of being able to unlock the field by clicking a button just in case the user entered the wrong data. I will password this button so a supervisor will have to make the changes.

Thanks again!

 

[Bat17]

in the after upfdate event of the field ad something like
me.myfield.enabled = false

in the current event of the form some think like

if nz(me.myfield,"") ="" then
me.myfield.enabled = true
else
me.myfield.enabled = false
end if


HTH
Peter