Yes/No or All Records

[jamjarr]

Hello All

I have a main form that has search filters on it with a subform in that stores the records. The filters I chose in the main filter the records in the subform.

In the records there is a yes/no field. I have the filter working ok on the yes or no option but I cannot get it for all records. The filter is a combo box with yes or no options. I need another option of all records. The filter get its data from the yes/no field in the database table.

I have Access 2003 but I need it backward compatible with Access 2000.

Is there a way?

Thanking you in advance.

 

[KeithG]

You could add the asterik * to your dropdown.

 

[ColinEssex]

To add "All" to a ComboBox see here

or look at the Developers Soutions CD

Col