Combo box is altering the data in my Master Table

[tbiceps]

I currently have a combo box, (Combo7) placed in a form which pulls its drop down list from a table (TBL_Warehouse_Process_Area). This table has one field, [Operations AREA]which simply lists the varied operational processes. This form has 3 combo buttons used to gather information from a user. This configuration is used to compare information housed in my main table (MasterTBLReport), but when selections are made from the DropDown menu, it changes the data in the (MasterTBLReport). I simply want it to compare housed data and return the results using a select query. Does anyone have any ideas where I'm going wrong?

 

[Remou]

Check if the combo box is bound to a field in your master table. You need only have the row source set to your look-up table, you do not need a control source.

 

[tbiceps]

Thanks Remou! As always you give great advice. I have my control source tied to my master table instead of the operations table. Before your post, I made the following changes: I changed my row source type to "Value List", and I entered the choices manually. However, my control source was still tied to my master table. Now, thanks to your post I have implemented a more reliable post. Thanks again!