Allow change to a field on new record only

[Grooz13]

Hello, I want my user to be able to enter a job number manually, but I don't want them to be able to change it once it's done... I had this code

 
If Me.NewRecord = True Then
Txt_No.Enabled = True
Else

Txt_No.Enabled = False
End If

but access give me an error 2164
any idea ?

[pbaldy]

What exactly is a 2164 error? What event is the code in?

[Grooz13]

Ok error 2164 is I can't put enabled = false cause i'm focused on this field already , I just found out why it didn't work... BUT I have another problem... Enabled=false don't allow me do to anything else since access can't ACCESS (budumpishhhh) to the field if it's enabled = false... I want some code like allowchange=false

[pbaldy]

Not sure what you mean. Setting enabled to false will prevent the user from accessing it. You should still be able to get to the value via code, even to change it.

[Grooz13]

well enabled didn't fix my problems it wasn't working , but I used .locked instead and now it works

thx !