Wildcard / TempVar Criteria

[mrmims]

Hello,



How do I combine the * Wildcard with a TempVar?

I currently use:

Like "mcc_g1*"

to find all records beginning with MCC_G1. But now I have over 21 different "MCC" identifications and I don't want to create a different query for each.

How do I use a tempvar with the Like and * functions?????

I have tried:

Like [TempVar]![MCC]*

Like ([TempVar]![MCC])*

Like ([TempVars]![MCC] & "*")

And other variations.

Any help would very much appreciated!

Thank you

[rpeare]

like [Enter the MCC String] & "*"

if you're using it as a criteria in a query

[amrut]

Use the * when setting the TempVar itself
TempVars.Remove("MCC")
TempVars.Add "MCC","MCC*"))
use Like TempVars!MCC

[mrmims]

like [Enter the MCC String] & "*"

Worked great! Thank you