Scrolling thru a list box 1

[StayAtHomeMom]

Hello,
I have a form with an unbounded list box that I want my user to be able to quickly get to the record they want. (There is a LARGE number of records...) I know that if they type in the first letter, Access will jump them to the records started with that letter. Is there a way to let the user type in, say, 3 letters? So instead of just typing in "M", they could type in "MUR" and the list would jump to all those records starting with "MUR". I have Access 2000, and I know some VBA, if that's what it takes.

Thanks for any suggestions you may have!

 

[DreamerZ]

Change the list box to a combo box and what you want will work fine.

DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[SgtJarrow]

DreamerZ is correct....

If you must have the Listbox though, with some VBA code and some patience you can use a list box and a textbox to almost work like a filter....as you type in the text box, the listbox is filtered closer to what you have typed....then you select and drive on...

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[StayAtHomeMom]

Mstrmage,

A combo box is not an option, as the user needs to be able to make more than one selection in the box. Can you give me a little more detail about using a textbox as a filter for the list box in VBA? That sounds like the avenue I need to take.
Thanks!

 

[SgtJarrow]

If you need to allow for multiple selections, this also may not work....

The idea I proposed would make the list smaller and smaller as you typed in the text box, because you will in essence be applying a filter to the list box....as you type more and more, the choices will diminish. Eventually you will only have a choice or two that all begin similar to what you have typed...

let me know if you want to see it, but I don't think that it will work for you.

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[DreamerZ]

The only way I could see the filter list option working is if you use it to filter the original list box, clear the text box after a selection and then populate another list box with the selections.

That might work.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]