Pass para to query from form

[ppoindexter]

what do i add this statement so if a selection isnt made from a particular combo, the comob is ignored and the query uses only the values selected

[forms]![frmOne]![cmbOne]

something like this

[forms]![frmOne]![cmbOne] or is null ?

thanks

 

[KenHigg]

iif(isnull([forms]![frmOne]![cmbOne],"*",[forms]![frmOne]![cmbOne] )


Does this work?

kh

 

[ppoindexter]

i get an error

wrong number of arguments...

 

[KenHigg]

iif(isnull([forms]![frmOne]![cmbOne]),"*",[forms]![frmOne]![cmbOne] )

???

 

[ppoindexter]

the error went away
but...now the value isnt being passed to the query