Text box search multiple fields with subform?

[applevacross]

Hi all,

I am currently using a frame with two radio buttons controlling two combos to switch between search requests. I can enter by name or switch to serial and enter likewise. The output is generated in a sub-form of all records by that name or serial. Mostly name, since of course serial is unique.

However, I'd like to setup an unbound text box to search all fields within 1 table. Ultimately the search data will be output to a seperate sub-form. Is this possible, and am I making sense? Sorry, trying to be as to the point as possible. Basically I'd like to be able to search by any field in my table without having to pick radio buttons and such.

Any help is greatly appreciated. Thank you to all in advance!

 

[PHV]

Use a criteria like this:
"[field 1] & [field 2] & ... & [field N] Like '*" & Me![TextBox name] & "*'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[applevacross]

Thanks PH, what does [field N] identify?

Thank you, I appreciate your help!