Use input box in criteria

[ridsclan]

I want to use input box in criteria. But i've a problem when I need to find record.

Normally when use like "M*" in criteria , result will show all record start with "M". What need I do if I want to search all record that start with M use input box?

eg.

Criteria =[Enter name]

Please help.

 

[pbaldy]

Criteria:

Like [Enter letter] & "*"

 

[ridsclan]

Thank.

But I mean, I type "=[please enter name]"

When I run query there are message box there, then I'll type the name.

So how can I use the winld card there (in message box)

 

[pbaldy]

Don't type

=[please enter name]

as the criteria, type

Like [please enter name] & "*"

exactly like that into the criteria. Copy and paste that line. When you run it, you'll only see "please enter name", but the query will add the wildcard to whatever is entered by the user.

 

[ridsclan]

Thank a lot. Got it