Query criteria to select all records when All is selected in a list box

[pavin]

Hi All,

I was looking for a criteria in a query to select all records when a List Value such as 'ALL' is selected else filter only records that are selected in List box of a form. I tried the following in the criteria but No luck.

iif([Forms]![Form1]![List4]="ALL","*",[Forms]![Form1]![List4])

Thank you.

 

[alansidman]

Instead of ALL, leave blank and look at this video

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

 

[Micron]

No intention here of disagreeing with the proposed solution, especially since I didn't review it. However, if I see the problem correctly, there's a learning opportunity. I believe you have to use the LIKE operator whenever you use the wildcard (*).

iif([Forms]![Form1]!
[List4]="ALL","Like *",[Forms]![Form1]!
[List4])

Sorry, CANNOT stop the line from wrapping, no matter what I do.