wildcard search

[JonatABS]

I have a search query that lists the employee of the number that was entered into a search field. That is working nicely.

Howeer I want to be able to put any part of that employee ID or first name or last name or whatever into the search field, and have that display instead of having to enter the EXACT employee ID.

I tried to copy the criteria to all the fields in the query but only one of them works and its usually a tossup.

any help would be apprecited.

thanks in advance!

 

[Vassago]

Jon-K gave this to me, it let's you not only type in parts, but multiple parts as well. This should work for you.

 

[EleanorG]

Another notch

Is it possible to use this same code to search more than one field in a table. I got it to work but have a data base of instructional videos with more than one title on each video. Also could the query open something besides the table???

 

[Vassago]

This code feeds into a temp query which will display the datasheet results when run. Instead of having this happen, you can bound a form to this query and arrange the data to your liking.

And yes, you can have it search more than one field, just change the code like this...

 

[EleanorG]

I'm afraid I didn't explain well enough. There is one ItemRecordNumber for each video/set of slides. There can be various titles on the same video - Title1, Title2, Title3, Title4, Title5, Title6. I want to be able to put in "cruciate" as a keyword search and have it show me all the videos with the word cruciate in any of the titles.