change rowsource of bound combo..sometimes blank with filter on..

[nycdon]

I have subform with a bound combo, and checkbox to filter the combo. If
checked, I change rowsource of combo to be that of a certain criteria only;
if unchecked, shows for all.

The filtering works fine, except I realize that if filter is checked on, and
an existing record/row in subform does not meet the combo filter criteria,
the combo is empty.

is there way to filter a bound combo (when click to open dropdown), yet have
it show the bound data item, regardless if it meets filter criteria?

 

[Steve Schapel]

Nycdon,

You didn't mention what event you are using to manipulate the Row Source
of the combobox, but I am assuming it is After Update of the checkbox,
or some such. Am I right?

Instead, try it on the Enter event of the combobox itself. And then, on
its Exit event, set the Row Source back to the "unfiltered" data.

 

[Steve Schapel]

Instead, try it on the Enter event of the combobox itself. And then, on
its Exit event, set the Row Source back to the "unfiltered" data.

.... oh, and don't use Requery.