I have a form with a text box which allows the user to enter the name of customer and be given all their details in another form . When the name is entered the user runs a query which gives the results based on the value entered in the text box. However the text box only allows the user to enter the correct name or no records are shown. Is there a way to allow wildcard entries in the text box?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Wild card entries in a text box
- Thread starter Ed3m
- Start date
In my case I have a query which searches for a brand in a table in combination with customer data.
When you put the line:
Like "*" & [What description?] & "*"
in youre query and run it a msgbox will show up asking you :
What description?
Whatever you type in the Msgbox, it will search for it in the table with the * before and after it.
Now when you run a form which is based upon this query this MsgBox will ask you: What description? and the form wil show you all that is found according to your entry.
I hope this is what you are looking for.
Maybe bend it to youre needs a little.
When you put the line:
Like "*" & [What description?] & "*"
in youre query and run it a msgbox will show up asking you :
What description?
Whatever you type in the Msgbox, it will search for it in the table with the * before and after it.
Now when you run a form which is based upon this query this MsgBox will ask you: What description? and the form wil show you all that is found according to your entry.
I hope this is what you are looking for.
Maybe bend it to youre needs a little.
Upvote
0
Similar threads
- Question
