Combo box for selection purposes only

[msmithtlh]

I have some forms that get the criteria for queries, then have a button to run the query.



One of the fields on the form is a combo box for employee, so that the supervisor can select a specific employee for the data.
This is working fine, except when you close the form, it "thinks" you are trying to save the employee record, and gives an error,

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

I understand the concept of duplicate records, but I haven't changed anything, so why does it "think" I'm creating another record. How can I get a selection-only combo box to look at my employee table? Thanks!!!

[RuralGuy]

Is your ComboBox "bound" to a field in the RecordSource of the form? If so, why?

[msmithtlh]

Yes it is bound to the employee table. I'm not sure how to do it as an unbound field. Help with that would be appreciated.

[June7]

You solved by unbinding the control? This means the control does not have ControlSource. Controls used only as means to input filter criteria should not be bound.