Search all field in the table

[Alhousani]

Hi everybody,
How I can set a query to search in all table fields. In my table I have around 48 fields and I want to search for particular value from combo box if this value exists in any of those fields.

 

[The_Doc_Man]

I'm going to stick my neck out on a limb here. If you have 48 fields and they ALL can contain a given value that I infer comes from the same combo box, this table must contain what we call a repeating group. If this is true, the table is not normalized and therefore is causing you headaches.

If your table is as I think it is, you can't get there from here without doing a lot of things by hand. No automation will help you in this case.

If I have misread the situation, then I apologize that I did not understand your question. You might try to clarify your situation just a LITTLE bit more so we can see if I'm right in my inference.

 

[Alhousani]

Thank you for taking time to read my thread what I mean is I want to search in the table similar if you open the table and go to find and search in all fields but I want the desire value to be taken from text box or combo.