Locking a field after one entry 1

[MikeMcKeown]

Hi all,

i was just wondering if it was possible to prevent a user from editing a database field on a form. So they would be able to enter a value once and then they would be prevented from entering it again. i.e. locking the fields for edits

Thanks in advance

 

[lupins46]

You need to add code to two places to do this:
Assume the textbox is called txtMyField then you add the following code to both the txtMyField afterupdate event procedure and the FormCurrent event procedure.

If not isnull(me.txtmyfield) then
me.txtmyfield.locked = true
else
me.txtmyfield.locked = false
end if

Obviously use your own textbox name.

 

[lupins46]

I should have added that this protects enrtries as long as they are made through the one form. If you allow the field to be accessed from another form you need to do the samae there. If you allow direct access to the table then all bets are off!

 

[MikeMcKeown]

Thanks for that.