search function

[crich21]

I want to be able to click a command button on a form and have it display a question box "What item are you looking for?" then when the user enters a string I want it to search every field of the subform that string. Is this possible. The subform is based on a query.

Thanks
Chad

 

[llkhoutx]

Instead on a question, why not use a text box to hold the item, or maybe a combo box whose recordsource is a table of all items, and then use a button to build the sql string with the selected/specified itrem which is the recordsource for your query or better yet, a recordset?

 

[crich21]

don't think thats feasible

Further Detail:
I have a list of 2799 Parts the list contains part numbers, descriptions, vendor part numbers. What I am trying to do is search all three columns at once based on a user entered string of text or numbers. Also this must be a wildcard search "*" before and after the text to search for. Currently I have three buttons on my main form based on 3 queries but I don't want to have to type a part # in one search and it come up blank then have to go back and type it in, in the other searches as well. I hope this clarifies my problem.