Search in Many Fields at once

[liza_adam]

I have many fields in one form (Client1.. Client6) so what I want is when I put a number in this Text box it will search in all this 6 fields and show the form data depending in this search.
Note: all the data in these 6 fields is Unique

Please help me

Thanks

 

[llkhoutx]

Select * from YourTable WHERE
[Client1]=me!txtboxCriteria OR
[Client2]=me!txtboxCriteria OR
[Client3]=me!txtboxCriteria OR
[Client4]=me!txtboxCriteria OR
[Client5]=me!txtboxCriteria OR
[Client6]=me!txtboxCriteria;