Filtered Query

[LonghronJ]

I have a MyForm1 that's record source is based on a query that has few TempVars variables that are fed from MyForm2. Some of the variables will be null. Therefore, the query's criteria are

Like "*" & [TempVars].[Variable1] & "*"

, so the query still returns records when Variable1 is null while other variables may not be. My issue is that if Variable1 value is "roofing", the query returns "Roofing" and "Waterproofing". How can I set the criteria so that it only returns "Roofing"?

[Minty]

That will also make the query very inefficient. Try it this way assuming you don't need any wild-carding normally;

= [TempVars].[Variable1] OR [TempVars].[Variable1] is Null

[LonghronJ]

That will also make the query very inefficient. Try it this way assuming you don't need any wild-carding normally;

= [TempVars].[Variable1] OR [TempVars].[Variable1] is Null

That seems to do the trick on this query. I have used this format before, but I don't think it always work. That's why I've used the wild card version. Meantime, I'll convert it to your suggestion and will come back if I have issues. Thanks for your help.