G
Guest
I have a combo box using a Salesrep table as its RowSource. In the Salesrep
table, I have an 'Active' checkbox. I want the combo box to show only Active
salesreps so I changed the RowSource to an SQL statement to achieve that. The
problem is if you go back and look at historical records for a sale, if the
Salesrep is no longer active, the combo box appears to be empty. I know the
data is there but can't be seen because of my RowSource and because I have
set LimitToList to Yes.
I have created a workaround by placing a TextBox behind the combo box
(disabled and locked). The TextBox is also bound to the same field. I made
the combo box transparent so that if the combo box is empty, you will see
through it to the text box. Does anyone have a more elegant solution for this
issue?
table, I have an 'Active' checkbox. I want the combo box to show only Active
salesreps so I changed the RowSource to an SQL statement to achieve that. The
problem is if you go back and look at historical records for a sale, if the
Salesrep is no longer active, the combo box appears to be empty. I know the
data is there but can't be seen because of my RowSource and because I have
set LimitToList to Yes.
I have created a workaround by placing a TextBox behind the combo box
(disabled and locked). The TextBox is also bound to the same field. I made
the combo box transparent so that if the combo box is empty, you will see
through it to the text box. Does anyone have a more elegant solution for this
issue?