SQL Statement - Filter

[Tony]

Good Afternoon,

I have an SQL statement that pulls inventory within a
form and I have added a check box to give the user the
ability of pulling only "Active" status inventory or,
when it is un-checked I would like it to pull ALL.
Currently it works for the Active (checked = -1) but when
its unchecked it returns nothing. Here is my criteria:

IIf([Forms]![frmPCodeSearch]![Active]=-1,"Active",IIf
([Forms]![frmPCodeSearch]![Active]=0,""))

The possible statuses could be Active, Inactive,
Suspended or Reserve. How do you pass more than one
possible status (i.e. Active, Inactive, ect) when
[Active] = 0. Any help would be much appreciated.

Thanks.

Tony

 

[tina]

how about

IIf([Forms]![frmPCodeSearch]![Active]=-1,"Active",IIf
([Forms]![frmPCodeSearch]![Active]=0, Like "*"))

hth