searching part of text

[Tech]

hi there,

i can't remember if I posted this, but if so, I DEEPLY apologise.

I have a query which searches a label of a track via a form with a text box.

what I need to know is, if we enter text in this box, how can i make the query search PART or ALL (really PART) of the inputted text. so if we have a track called Cafe Dal Mar but we can't remember it, the user simply enters Cafe and maybe 4-10 results of that title appears...eventually we go thru the listed tracks and find that track.

how do I do this?

Thank-you in advanced

 

[Jack Cowley]

Use a combo box instead of a text box. Base it on the query and make it a Totals query. This will then show only the names that exist in the query, without duplicates, and you do not need to look for partial names. Also, when the user starts to type in the name the combo will start moving towards the name you are looking for. If you type in Z then the combo will immediately show the names that start with Z and will continue to narrow down the list as you enter additional letters....

If you want to stick to a text box then use code like this in the Criteria line of your query:

Like "*" & [Forms]![FormName]![TextBoxName] & "*"

hth,
Jack

 

[Tech]

yeh, i know what u mean...like what i had to do for my uni project

but is there no other way? sure, i may do this, but prefer doing the initial idea - if there isn't, no bother, i will use ur advice

 

[Jack Cowley]

If you want to stick to filling in a text box on a form then my second suggestion will find Cafe Del Mar if you enter Del or if you enter Cafe you will get back as many records as there are that have Cafe in the name....

I hope I understood your response...

Jack

 

[Tech]

no..that doesn't work

it has to be an accurate piece of text in order to search the whole database

 

[Jack Cowley]

I don't understand your response. All I can say is that if the input is not accurate then the output won't be either.

Jack