Query Criteria Popup

[Rustin788]

Hey,
I am creating a query for people that are not fluent with Access so I will need to have it pop up asking which customer they are looking for. My problem is they often don't know/have the exact name that is in the system so I need the popup to occur and have an input using something like: Like "*" & "Popup info goes here" & "*". Is there a possible way to do this?

Thanks for the help.

[pbaldy]

I personally would use a form, but enclosing your prompt in brackets should work:

Like "*" & [Popup info goes here] & "*"

[Rustin788]

I personally would use a form, but enclosing your prompt in brackets should work:

Like "*" & [Popup info goes here] & "*"

I had completely forgotten about forms. I ended up going that route and now I don't have to worry about them editing stuff in design view. Thanks!

[pbaldy]

Happy to help!