Ask Experts Questions for FREE Help !
Ask
    erosinski's Avatar
    erosinski Posts: 12, Reputation: 1
    New Member
    		  
    #1

    Sep 6, 2005, 06:02 AM
    Go to record on form button
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Sep 6, 2005, 06:14 AM
    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.
    erosinski's Avatar
    erosinski Posts: 12, Reputation: 1
    New Member
    		  
    #3

    Sep 6, 2005, 06:17 AM
    A lot easier than what I had in mind, thank you
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Sep 6, 2005, 10:51 AM
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

I need to record [ 3 Answers ]

hi, im Ashley, i love singing and i want a website or program i can download to record my music, and singing, does anybody know anything that i could use to record with? :p

Pressing a button is work? [ 74 Answers ]

I once worked in an apartment building New York City where I met this Jewish gentleman who always requested that we press the elevator button for him and open his apartment door because if he did it it would mean that he had worked and he was sinning. Is this an official belief Jewish community or...

Reverse Button [ 2 Answers ]

I have installed the remote control for my Hampton Bay fan. Everything works (lights, dimmer, fan, fan speed) but the reverse button. I lost the instructions. Does anyone know how to activate the "reverse button"?

Funny Red button on tub spout? [ 12 Answers ]

The tub spout has a red button on the top of it, when I took it off I noticed some sort of valve in there where the one I bought to replace doesn't have that and of course the stem from the way is too short for the one I have now, I guess I can make a new pipe, but I was really wondering what that...

Shower button [ 2 Answers ]

This morning I pulled the shower button and nothing came out of the shower head. Water just came out of the facet. The unit is a "WALTEC" and we installed it in 1993. I had noticed for a while now some water coming out of the facet during a shower but this time all the water came out of the facet....

View more questions Search