Access Help with joined tables in Access

[jocerio]

I have a subform that is made from a many to many query with 3 tables. It selects an employee number from a combo box field and then populates their name and rate of pay. The user enters his hours and the updates the field, it calculates the total labor. Problem is if the user accidentally deletes his name from the first filed, it deletes him from the employee table. How can I stop that?

 

[alow]

You're probably going to require code for this, combo boxes don't have the Read-Only property that text boxes do. I'm not great at it, but a Google search for "Access combo box read only" should return some useful results.