need help figuring out this search form (example attached)

[mic907]

I have found an example of a search form that I really would like to replicate, but I'm have no idea how to implement it into my database. i have attached a stripped version of my database (only consists of a table) and the database with the search form i would like to implement.

Basically, I need my search form be able to sort through a list of consultants so that the user will know whether or not they're in the database already. The fields that I would like displayed are last name, first name, and phone number and social security/fed. tax ID. Any suggestions would be much appreciated!

 

[mic907]

any suggestions?

 

[Rickster57]

Combo Box

Why Not just create a combo box on your form that displays those 4 fields?
When the user starts to type in the lastname the combo box displays it immediately. The user will know if the consultant is already in the database.

 

[mic907]

I'd prefer to have a separate form so that a user can search for a listing by last or first name, and to see if all records available that match whatever criteria they use (ie more than one user with the same last name, like all 5 Smith's in the database or whatever). I think it is also less confusing, as my main form has enough fields all over the place.