Access Form - Lock Fields from Editing

Apr 18, 2014
Reaction score
I am trying to create a "Master Form" where the end-user selects a technicians name from combo box based on a query. The Combo Box has an On Change procedure that updates 6 additional (text) fields on the form re: tech number and location. That process seems to work just fine.

Where I am getting tripped up is - if the data entry person goes back to an existing record and selects a different technician in combo box the information is updated with the new technician data - which would then be incorrect.

I have been able to lock the text fields:

Private Sub txtTechnicianName_Exit(Cancel As Integer)
If IsNull(Me.txtTechnicianName) Then
Me.txtTechnicianName.Locked = False
Me.txtTechnicianName.Locked = True
End If

And tabbing into the field - I cannot change the data but if I go back to the combo box and select a different technician - the 6 text fields are updated with the new technician's information.

What I am trying to accomplish is locking the 6 text fields once saved.

Any insights on where I am going wrong would be greatly appreciated - Su


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question