Displaying 1 / All records

S

Steve

Hi,

I have a form with a list box and check box on it.

I want to either select a Value from the list box or
Select the checkbox to display All values.

Ive created a query to retrieve the selected data but cant
remember for the life of me the criteria needed to do this.

Can anyone help?

Cheers,
Steve.
 
J

John Spencer (MVP)

Enter in the criteria cell:

Criteria: Forms!FormName!Listbox OR Forms!FormName!Checkbox = True

Access will restructure this after you save the query, but it should still work.
 
Top