Record Search for Specific Field?

[Dedicated]

I would like to generate a command button where I can search by first and last name to pull the record up in my main form. I have (2) fields [ProviderFirstN] and [ProviderLastN]. Do I need to create a macro?

My main table is linked to the "qry Provider Main".

Thanks,

Dedicated

 

[LarryDeLaruelle]

A simpler approach would be to use a lookup combo on the form.

If you are using a query behind the form, concatenate the Last and First names (call it fullname).

On the form (make sure the wizard is on), add a combo box, select the 3rd option (look up a record), add the record's primary key and the fullname field, and then follow the rest of the prompts.

Should do what you are looking for.

HTH

Larry De Laruelle
ldelaruelle@familychildrenscenter.org