text search box searchforrecord

[michael61182]

Hi,

Please someone help, I've been trying to complete this for 2 days now and cannot find the correct solution.
I am fairly new to Access but fairly knowledgeable as well; I have taken 24 hrs of Access training.

I have an employee form and would like to have 2 text boxes at the top of the form to search for SSN or Last name and navigate to that record, all within the same form. I'm sure this is possible and have seen this done a few times with a combobox, but I just want a text box. I'm able to create a button that will open a query for the same, but I dont want to open a query, I just need it to navigate to the actual record.

Can someone please help point me in the right direction?

Now just looking at the last name search, I have a text box -> txtqryLastName and a button cmdSearch. I know I can add code or a macro to the afterupdate filed of txtqryLastName so if thats an easier solution that is fine with me, I just need to finish this.

I've been able to get around with light VBA code and have tried multiple solutions but am just lost now. If someone can give me a macro that will work that is just fine with me too.

Now I have completely back tracked just trying to get something to work and have setup a button with ******* macro -> searchforrecord, Record - First, Where txtLastName = "Jon".
It seems this does find the record but instantly goes back the record I was already on. It happens so fast that I can barely see the screen flicker.

Please advise.

 

[alansidman]

maybe something like this:

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

 

[michael61182]

Thank you. The combobox search works perfectly.