Displaying 1 / All records

  • Thread starter Thread starter Steve
  • Start date Start date
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.
 
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.
 
Back
Top