aaarggggh! - using criteria to filter query based on combo box 1

[tractorvix]

Hello all,

I've got a couple of forms which are query based and the combo box update changes the criteria for the query and using a docmd.requery shows the appropriate results on update

I am using

Like IIf([Forms]![frm-reprintnote]![OrderNocombo] Is Null,"*",[Forms]![frm-reprintnote]![OrderNocombo] & "*")

which is working brilliantly for all but one of my fields. This field can contain null values so the "*" does not return all of the records, just those that contain something. I've tried using

Like IIf([Forms]![frm-reprintnote]![OrderNocombo] Is Null,like "*" or is Null,[Forms]![frm-reprintnote]![OrderNocombo] & "*")

but because of the other criteria I get an error stating the query is too complex.

Any ideas? work arounds?

Much appreciated.

Vix

 

[PHV]

Like [Forms]![frm-reprintnote]![OrderNocombo] & "*" OR [Forms]![frm-reprintnote]![OrderNocombo] Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tractorvix]

PHV, you are a star.

That works brilliantly.

Thank you so much

Vix