I want to put a button on the form that pulls a string from a text box and goes to the unique "sorder number" in the form. This will keep my users from having to click next a hundred times to get to a record. I have no time to try and figure out the vb code so if anyone already has an idea how to do it, it would help me a lot.

Running access 2003

I want to put a button on the form that pulls a string from a text box and goes to the unique "sorder number" in the form. This will keep my users from having to click next a hundred times to get to a record. I have no time to try and figure out the vb code so if anyone already has an idea how to do it, it would help me alot.

running access 2003

Use the Combobox wizard to build a Search combo (3rd option). That will allow the users to select the record and position the form to that record.

A lot easier than what I had in mind, thank you

alot easier than what i had in mind, thank you

You're welcome, that search combo is a godsend. I actually use the code it generates in several different scenarios.