I feel very silly asking this, as I'm sure the answer is right in front of me. I have a form where the user can select 3 different vendors to compare their products. I am using combo boxes to select the vendors from the drop down list. The problem is that when I change 1 vendor, the other 2 change as well. The vendor field in the table is a drop down list. I have tried changing the combo box and row source, it's still not working.
Each combo box is a drop down list based on my Vendor table, which lists all vendors. I used unbound combo boxes, thinking they would be separate, as opposed to dragging the field in from the list of available fields. Is there a way to have each drop down list hold the same values, without being bound to the same field?