How do you Lock a Field after Data has been input? 1

[pgoulet]

We have a customer form that opens in Edit mode.

We want to add a field "referral" that onces that field has data, it can NOT be modified using this same form. But the rest of the data, need to still have the ability of being modified.

Thanks

Paul

 

[KenReay]

HI

How about in OnCurrent Event of form

If IsNull(referral) Then
referral.Locked = False
Else
referral.Locked = True
End If

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[pgoulet]

Thanks,

That is just what I needed. Works like a charm.

Paul