Another Combo Box question

[inx3us]

I apologize in advance...
I have 1 table with many columns. I have a form which shows all the fields in a record. I would like to have 1 combo box which can be used to search 3 of the columns and of course reflect the chosen record. The example would be a table containing:
First, Last, Addy, City, State, Phone# , SS#, Serial#
I would like to search in one combo box for either SS# or Phone# or Serial# and upon finding a match hit enter and show the entire record in the form for the matched search item.
Thank you.

 

[John Big Booty]

The search tool in this thread might do what your looking for.

 

[inx3us]

Combo Box search

Thanks for the reply. I have seen this search before in a slightly different form. It seems a bit much for my needs. I just thought of this idea, what if I concatenate the three fields I want to search on into one new field and add a separator. I can then search for a phone number OR ss# OR Serial# in this new field and return a record that contains it. Will the number I am looking for always have to be at the beginning of this new field I've created or can I search "inside" this new bigfatnumber for what I need?

example-
Soc.Sec# Phone# Serial#
813-04-8865 555-8977 A900SC22
becomes-
813-04-8865/555-8977/A900SC22

and I search for the phone number
555-8977

 

[rolaaus]

Will the number I am looking for always have to be at the beginning of this new field I've created or can I search "inside" this new bigfatnumber for what I need?

example-
Soc.Sec# Phone# Serial#
813-04-8865 555-8977 A900SC22
becomes-
813-04-8865/555-8977/A900SC22

and I search for the phone number
555-8977

Not if you use the LIKE search criteria. It would go something like this,

Select SomeFiels from myTableName WHERE SearchField LIKE *555-8977*

If you are passing this value via a form, then replace the phone number with your forms control name, rememberiing to use the apostrophe for text searching (since you'r concatenating multiple field values)