Query criteria from a Form

[gheyman]

I have a query where I use the value from a Combo box on a form as the criteria
Forms]![frmEstimates]![ComboPidSelected]

This woked fine. But I need to adjust it so that when nothing is selected in the Combo Box that the query puled Everything. So I tried an Iff formula

IIf(IsNull([Forms]![frmEstimates]![ComboPidSelected]),"*",[Forms]![frmEstimates]![ComboPidSelected])

Is my formula wrong or maybe this is something you cannot do.

I get an error message: "This Calculated column contains an invalid expression"

Pre IIf statement it worked fine.

 

[xenou]

Are you using LIKE in this query? It's not clear how the expression is being used. You should also be debugging the result of the expression:

msgbox IsNull([Forms]![frmEstimates]![ComboPidSelected]),"*",[Forms]![frmEstimates]![ComboPidSelected])

I would test this way with a null value, an empty string, and an actual value.

 

[gheyman]

This is in the query under the Criteria section - not in VBA

I don't understand the msgbox portion of what you suggest.

 

[xenou]

You can use the msgbox on your form.
Add a button, and have it display the value of the expression.
The same can be done in the immediate window or in other ways - you don't need to use a msgbox, you just need to be able to debug by seeing the evaluated result of the expression.

If you are using this in a query you need a name for the column with the expression.
MyColumnName: <expression>

Did you confirm you are using LIKE ?