How to prevent data from changing

[Dave H]

I have a form that with a combo box that is populated by a query. The user can select a value from the combo box which then opens a form filtered by the chosen selection. However I have noticed that the identifier field gets changed when the form is closed. I would like to prevent the identifier from being changed will still allowing the user to make a selection. I am open to any suggestions.

 

[RuralGuy]

What identifier field on what form?

 

[Dave H]

I have one main table with thousands of records and about 25 fields. I want users to be able to edit most of the fields. A couple of fields I use for identifiers, none of these fields are unique identifiers. When the user opens the database he is prenseted with a Form that lets him choose which records to edit. This form has a combo box which is populated by a query that returns only unique values from the main table. When the user selects a grouping from the combo box then hits a command button a form showing the relevant fields filtered by the grouping selected opens. The issue is that when you make that selection it changes the value in the 1st record from the main table to the value selected. I want to prohibit the change. When I change the 1st form to not allow edits it prohibits the user from selecting a value from the combo box. Hopefully this is a little clearer.

 

[RuralGuy]

Remove the ControlSource from the ComboBox. Leave it UnBound.

 

[Dave H]

That did it. Thanks for your help

 

[RuralGuy]

Glad I could help.