OK. I posted a thread and got some response but it wasn't what I was looking for. Here is exactlly what I have now and what I am trying to do.

I have a form called frmGeneral, it has various text boxes on it (name, address, ssn, sex, etc.) I also have a text box called txtSearch, and two buttons called cmdSearchSSN and cmdSearchSelect. What I want to do is have the user type in the txtSearch box what SSN they are looking for (possibly auto-fill); after they enter the SSN they will click on cmdSearchSSN. When it finds the SSN they are looking for I want them to click on the cmdSearchSelect and have it fill in the information it recieves from the database (FEDS.mdb). Also do you think it would be better to just cut out the cmdSearchSelect button and just have it fill in the info once you hit the cmdSearchSSN button and it finds the appropriate info?

If anyone can help me, I really need it. Thank you