An IIf Statement as criteria for query: select all? 1

[Abi1]

I'm trying to write a query that selects according to details on a form. For one field, I want to be able to select the field value (from a combo) or select all. I'm put a check box for selecting all.

How do I write a query whose criteria are: If the checkbox is ticked, select everything in this field, otherwise select the value from the combo box.

Thanks,

Abi

 

[tlbroadbent]

You could use something like this in a query.

SELECT tbl.* FROM tbl
WHERE tbl.col1 Like "*" & IIf([forms]![frmSelect].[optAll],"",[forms]![frmSelect].[CboSelect]) & "*&quot);
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin