Combo box problem with form filter

S

Samantha

Hi All,

I'm applying the form filter based on a selection from a combo box.
My problem is that when the filtered query has no result, the item selected
in the combo box does not show. Why is this happening? Is this normal
behaviour for a combo box and filtered form? What can I do to fix the
problem?
Any help is very much appreciated. Thanks.
 
J

John Vinson

Hi All,

I'm applying the form filter based on a selection from a combo box.
My problem is that when the filtered query has no result, the item selected
in the combo box does not show. Why is this happening? Is this normal
behaviour for a combo box and filtered form? What can I do to fix the
problem?
Any help is very much appreciated. Thanks.
Click to expand...

If you're using a combo to select records, it should be *unbound* -
nothing in its COntrol Source.

Check your data: if you've been using a bound combo to select records,
you've almost surely been overwriting the combo's control source field
with the selected value prior to moving to a different record.

John W. Vinson[MVP]
 
Top