Dropdown list subset of display value

[Guest]

Is it possible to have a combo box with a dropdown list that is a subset of
the value the combo box displays.
I have a list of contacts in a combo box. I only want the dropdown list to
show the "Active" ones (there is a yes/no field in the contacts table called
"Active").
The displayed value in the combo box should show "All" contacts since some
of them have become "Inactive" as time moves on.
If the rowsource for the combo box is set to show only the "active" ones
then records with contacts that are no longer active do not display anything
in the Contact field.

Any help would be much appreciated

 

[jahoobob via AccessMonster.com]

Add (Where Active = "Yes") to the end of the Row source property of the combo,
in front of the last semicolon.