Search for button (1 Viewer)

Hi

Can you help please.

I have form where i would like to add search button, which would call for a small form with a couple of the fields and search button.

Let just say "form1" where are the fields like "id", "firstname", "surname", "dob" etc...
When you open the "form1" you can scroll through data already in table.

When you press search button it calls new form "form2" where are couple of the fields "firstname", "surname" ( these are i supposed unbound ). And search button

No problem so far but now.

When you enter either "firstname" or "surname" on the "form2" and hit the search button it will find the record in the table and get the rest of the record in the "form1".

I have tried to search the forums but i got even more confused.

Thanks very much for your help

Look at "DemoSearchRecordA20022003.mdb" (attachment, zip).
Oepn Form1 and try. Adapt it in your mdb.