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

Quote:

---

Originally Posted by erosinski

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

Quote:

---

Originally Posted by erosinski

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.