In the gotfocus of the combobox, you can set the rowsource to whatever is correct based on the checkboxes.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only