I'm trying to populate a combox box. There three tables that the combo box can have values for. Depending on what the user clicks (check boxes) The combo box only has one field associated with it. So if the user wants to check Box a, only the table with Box A data in it will populate the combo box.

Right now, it gets populated by placing a thisform.comboboxname.rowsource = tablename.field1 but it only sits on the first record.

TiA

Jeff