prevent update in a form

[bilalo]

I have a form that contains the following two text boxes: item name and item price, I want to allow the users to insert a new item, but after inserting an item, I want to prevent them from changing its name. I tried every possible vba solution on the item name(before update, after update, ....) but didn't reach the solution. Any help please?

[Bob Fitz]

I have a form that contains the following two text boxes: item name and item price, I want to allow the users to insert a new item, but after inserting an item, I want to prevent them from changing its name. I tried every possible vba solution on the item name(before update, after update, ....) but didn't reach the solution. Any help please?

Shame you didn't show us what you've tried.
Did you try setting the Locked property of the name control in its After Update event and also in the forms On Current event?

[bilalo]

Shame you didn't show us what you've tried.
Did you try setting the Locked property of the name control in its After Update event and also in the forms On Current event?

If I lock the item name, the users will not be able to insert new records since they can not type the item name

[Bob Fitz]

If I lock the item name, the users will not be able to insert new records since they can not type the item name

They will if you UNlock it in the forms On Current event subject to the control being Null

[Bob Fitz]

You would need the following code in the forms On Current event and the controls After Update event:

    Me.YourName.Locked = Not IsNull(Me.YourName)

You would need to substitute YourName with the name of your control

[bilalo]

You would need the following code in the forms On Current event and the controls After Update event:

    Me.YourName.Locked = Not IsNull(Me.YourName)

You would need to substitute YourName with the name of your control

Thank you, it worked perfectly