Query to select just one product or all products

[TD]

I have this expression in the criteria section of a query:

IIf(Forms!frmReports!cboProductID="<ALL PRODUCTS>",[tblProducts].[ID]
Like "*",Forms!frmReports!cboProductID)

(the syntax of the above expression may not be exact because I'm trying
to write it from memory us now)

I have a form with a combo box that I fill from a Union query that adds
the phrase "<ALL PRODUCTS>" so that when you click on this combo box
the first item in the list is "<ALL PRODUCTS>".

On the After Update event of this combo box I run a report based on
another query that has, as one of it's parameters, the item selected in
the combobox. The expression above is suppost to return all products
if the user selected "<ALL PRODUCTS>".

The espression above does not produce any errors but the query returns
no records no matter what the user selects. If I replace the expression
above with an actual product ID in the criteria section of the query
then the query it runs correctly.

Any ideas as to what I need to do to fix this?

Thanks,
TD

[Danny J. Lesandrini]

Sure, just change the record source for the combo box ...
Forms!frmReports!cboProductID

to this ...

SELECT '' As ProductID, '<All Products>' AS ProductName From Msysobjects
UNION SELECT ProductID, ProductName FROM tblProducts
Order By ProductName
Now, the bound column will return empty string for "all products"
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/

"TD" <dl**@adsi-sc.com> wrote ...

I have this expression in the criteria section of a query:

IIf(Forms!frmReports!cboProductID="<ALL PRODUCTS>",[tblProducts].[ID]
Like "*",Forms!frmReports!cboProductID)

(the syntax of the above expression may not be exact because I'm trying
to write it from memory us now)

I have a form with a combo box that I fill from a Union query that adds
the phrase "<ALL PRODUCTS>" so that when you click on this combo box
the first item in the list is "<ALL PRODUCTS>".

On the After Update event of this combo box I run a report based on
another query that has, as one of it's parameters, the item selected in
the combobox. The expression above is suppost to return all products
if the user selected "<ALL PRODUCTS>".

The espression above does not produce any errors but the query returns
no records no matter what the user selects. If I replace the expression
above with an actual product ID in the criteria section of the query
then the query it runs correctly.

Any ideas as to what I need to do to fix this?

Thanks,
TD

[TD]

Thanks for all the efforts to help but I stumbled onto this solution
which works perfectly!

LIKE IIf(Forms!frmReports!cboProductID="<ALL
PRODUCTS>",[tblProducts].[ID] =
"*",Forms!frmReports!cboProductID)