Jump to record action available?

[AlfredNor]

Id like to put a field in the header of my form that will jump to a record based on partial entries typed in.

For example...

Jump to: Donh

will jump to the Donhoo, Keneeda record.

Is this possible? It would help with multiple entries.

Im going to search for articles about setting up a search form here in the forums, but can the Jump to function I want be done differently so people dont have to search each time to see if the record exists?

Im also thinking of linking this function with a drop-down list..based on the values in the primary key....so that people can scroll through a list of customer names...and on clicking it, they are jumped to that record....any thoughts?

 

[Jack Cowley]

Create a combo box on your form using the Wizard. On the first screen of the Wizard select the third item, "Find a record...". Finish the Wizard. Now when someone starts to type in Doh the combo box will 'jump' to the closest item in its list and will continue to narrow down the selection as you type. When you have the one you want hitting the enter key will display that record on your form.

hth,
Jack

 

[AlfredNor]

thank you very much

I feel so dumb for it to have been that simple. (Strange that the help cant index that info in a way where people can find it)

thank you and good health.

Alfred

 

[Jack Cowley]

You are NOT dumb but Access Help is! I am glad that my suggestion will work for you and continued success...

Jack

 

[YUPAPA]

oh HiHi!

Is this only works with combo box??
Cuz I want to do it using textbox!

I have another question!
Can I do two forms, the first one is for user entering a primary key. Then it will jump to the next form when they press enter. On the next form, it will show the data of the records which has the same primary key the user entered.

Do I need to know VB to do that?? How is the next form going to know what the user entered in the text box and then display the result? Using Query?? How?


Please help, I am an absolute MS Access Newbie.

I am familiar with mySQL

 

[ghudson]

YUPAPA, check this old thread out for how to use a text box...

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34251

HTH

 

[YUPAPA]

oh thank you... you are so nice!