Access Form - Lock Fields from Editing

S

SuGilliland

Joined
Apr 18, 2014
Messages
1
Reaction score
0
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
Else
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

Similar Threads

Can a Check Box Prevent Other Fields from Being Used? 1
Multi page tab 3
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Combo Boxes - DISPLAYING multiple fields after choice is made 5
Access Microsoft access database(creating a search engine form) 0
Combo Box to change fields 5
Data entry for a table from a form 2
Data Entry Form. 3

Top