What I want is a list of companies in the combo box. Depending on the checkbox the list must show all companies or only the current companies.
So it seems the rowsource of the combobox should be (depending on field and table names) similar to
Code:
Select chrCompany from tblCompany where ysnCurrent = True
You can test the sql in the query designer.
I think you may have some structure issues, but I really would recommend you tell us the business facts in plain English. Readers need to know what you are trying to do before they can offer suggestions/options as to how this might be accomplished.
Good luck.