Help with Criteria Expression in Query - VBA? 1

[pdldavis]

Hi, I'm building a report where the criteria for one particular field is based off a combo box. I need to add a selection for all - "Like *" when entered manually. I have not been successful getting anything to work. The problem is "*" is taken as a literal character instead of a wild card.

One person suggested a union query, which helped but did not produce the desired results. He suggested this could also be done in VBA.

I would like to write something similar to this, except one that works:

IIf([forms]![frmMenu]![Cbosus]="All",([TblPunchlist].[Start-up System]) Like "*",[forms]![frmMenu]![Cbosus])

Any help would be appreciated.

Thanks, Dan

 

[mincefish]

You could try using querydefs in VBA. This FAQ might point you in the right direction...

faq701-2328

Hope this gets you started!

Mincefish

 

[pdldavis]

That was the assistance I needed. Thank You.