Search results

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...

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...