I have a main form called Workorders by Detachment. It has a combo field that lists all possible detachments, when a detachment is chosen all other fields (address, phone....) populate with applicable data. The form is based on a table called "Detachments" and sorted by detachment name.
I do not want the user to be able to change or edit data it's function is to choose the detachment and show its data. It will have a subform that shows all files associated to the detachment and all applicable work hours for each tech. When I try to change the form so that users cannot edit, the combo field does not respond (cannot choose a detachment). Currently when I open the form and choose a detachment and then exit I get an error that says the table cannot be updated because it will create a duplicate values in the index, primary key or relationship.
The primary key for this table is CustomerID (autonumber) and it is related to workorders form. I cannot change this primary key.
Sorry to be so long winded. Wanted to ensure all the information was here.
Thanks in advance,
Jeannie
I do not want the user to be able to change or edit data it's function is to choose the detachment and show its data. It will have a subform that shows all files associated to the detachment and all applicable work hours for each tech. When I try to change the form so that users cannot edit, the combo field does not respond (cannot choose a detachment). Currently when I open the form and choose a detachment and then exit I get an error that says the table cannot be updated because it will create a duplicate values in the index, primary key or relationship.
The primary key for this table is CustomerID (autonumber) and it is related to workorders form. I cannot change this primary key.
Sorry to be so long winded. Wanted to ensure all the information was here.
Thanks in advance,
Jeannie
