Prevent Dialog Box from Popping Up

[nguyeda]

Hello, I tired to search for help on this topic but I can't find anything specific to what I'm looking for.

I have a table that has a long list of order numbers, the 1st 5 mean location like:

THOQR1234WERAJS12
ASKLFJ1432WEJKLAKS
THOQR1234WKLAJS17
THOQR1234WKIAJS13
GASDKAL123ASF0800
ASKLFJ1432WYUKL123
GASDKAL123ASDK123

I'm trying to filter out "ASKLF" and "THOQR" so in the criteria I put Like [THOQR]&"*" and in the next lineLike [ASKLF]&"*"


I want to run this report over and over again but including more parameters. I know they are right. The column name must remain "Orders."

This is querying a query from anoter database.

So how do I keep this parmater box from popping up?

 

[pbaldy]

Enclosing it in brackets makes Access think it's a field name. Try

Like "THOQR*"

 

[nguyeda]

You are great! Thanks!

 

[pbaldy]

Happy to help!