Combo Box on form updates unintentionally

[zipmaster07]

I have a simple form that pulls off of a table called contractors. This table has infomation relating to a contractor like the contractor_name and contractor_id. On the form is a subform that pulls off a table called leads. The subform pulls all the leads where the contractor_id is the same as the one that is currently being looked at on the main form. Instead of using the built-in record selection tool that is at the bottom of every form I put a combo box that lists all the contractors so that you just select the contractor you want to see from the drop down by contractor_name. It brings up the the record and its corresponding data just fine, however when you choose one record from the drop down and then choose another record it overrights the contractor_name field on the actual table and sets it to the contractor_id of the record you just selected.

For example given the following

============================
| contractor_id | contractor_name|
------------------------------------


| 1000 | Contractor A |
| 1050 | Contractor B |
| 1100 | Contractor C |
============================

If I choose Contractor A the form pulls up all the leads assoicated to Contractor A, however, once I'm done looking at Contractor A if I decide to look at Contractor B and select them from the drop down it updates, or rather changes, the contractor_name field of Contractor A to 1050 (because that was the ID of the record I just went to) so the updated table now looks like this:

============================
| contractor_id | contractor_name|
------------------------------------
| 1000 | 1050 |
| 1050 | Contractor B |
| 1100 | Contractor C |
============================

As I continue to select more and more records from the drop down it continues to overright more and more contractor names.

I don't want the form to update anything, I just want to select the contractor from the drop down and have it display the rest of the form based on that selection. I tried changing a few update related settings on the Property Sheet of the combo box but this didn't change anything so I'm apperantly still missing something or not changing the right property.

Thanks

[June7]

Data controls (textbox, combobox, listbox) used as input for search/filter criteria should NOT be bound - nothing in ControlSource property.

[zipmaster07]

Thanks, working exactly the say I want it now.