Can it be done?????

[danson]

I have a form that lists about 200 items with a few little bits of info to make sure it is the actual thing my users wish to select. Once they select the item and click on the details botton a form open with all the details of the item.

What I was wondering was - is it possible when the first form opens with the initial list for the user to press a key on their keyboard and the form scroll down to the choices begining with the letter selected?

Bit like a find without actually going opening a find box and typing in your selection.

Not sure if this will make sence but I nearly always find a soultion or a helpful hint from here so I thought it was worth a try.

All hints tips and advice greatfully recieved

Danson

 

[llkhoutx]

That's what a combo box does with each key press.

One solution: If you have a subform with a textbox on a main form, one could requery the subform with each "KeyPress" (event) on the main form. The subform, of course, being filtered by the contents of the text box. Depending on the number of records and where the data is located (on a network) this may be slow.

The keypress event passes the Ascii for the key pressed, one may have to build the filter, rather than using the textbox.

I use the KeyPress event to mask the display of passwords when prompting the user when building Oracle connections. Sarbances-Oaxley at work. Yeah!

 

[danson]

The form is in datasheet view from memory - will need to have a better look at it. It is just every time I or one of the others open it at work you just tend to scroll to the entry you want. After you do it you always think it would be great to just press a key and it take you to the start of that aphabetical listing. Sound silly but thought it was worth a try to see if this can happen easily.

Tahnks
Danson

 

[llkhoutx]

If you have hundreds of thousands of records, you could be asking how to create a performance issue.

Sounds like you're just displaying too many records. Adjust your record source criteria.

 

[aleb]

Why don't you create a listbox, press any letter see how it scrolls to that letter. Unfortunately it works only with one letter, means if you try to search the whole word selection will jump all over the lstbox.

 

[KeithG]

You could create an unbound text box and use the after update event to filter the form. For example if the user entered Kie it would populate all records with Kie.

 

[danson]

More help -please

Keith G

Can you tell me how to create an unbound text box and use the after update event to filter the form.
What do you put in the after update event.
I am very new to all this - need spoon feeding

Thanks for the suggestion

Danson

 

[Oldsoftboss]

Try here...

http://www.access-programmers.co.uk/forums/showthread.php?t=110203