Search 2 fields simultaneously

[Nate]

I have a form that I would like to be able to search 2 fields at once on. In
my table I have First Name and Last Name in 2 seperate fields. As far as I
can tell, the only options are to search either the First Name, the Last
Name, or the whole form. I would like to be able to search First Name and
Last Name together, so if I am looking for Bob Smith and there are multiple
Bob's and multiple Smith's in my table I don't have to scroll through all of
them. Thanks in advance.

 

[Wayne-I-M]

Not really a good idea to use DLookUp for this as you may have 2 Bob Smiths

Best bet would be to create a combo to search through records.

Add the ID (primary field) 1st name and 2nd name fields to the combo.
There is a wizard for just this sort of thing.

Open your form in design view
Open the tool box and then select combos
Use the search for a record in your form" wizard

Good luck

HtH

 

[Nate]

Thanks! Not exactly what I had in mind, but definitely a solid solution.
Much appreciated.