List Box Text Selection

[TJBernard]

A few weeks ago I had a post in which I asked how a user could type in the text value of a list of selections in a list box, and arrive to that selection.

Such as if they type in "A" then "B", it goes to "Abby" rather than "Aaron" then "Ben". It was answered that this was not possible in MS Access with a list box, so after that I basically told the users I would look into it more.

I have finally cleared off my desk and arrived back to this small issue.

I thought of the idea to add a Drop-Down Combo Box to the form. I could use the functionality built into the Drop-Down Box to allow them to type in the person they are looking for in the List. Then click a button labeled "Find" and it would take them to the correct person in the list box. They could then function as before.

I just could not figure out the code to put behind my "Find" button. I am not sure if you can do a "Goto record" against a List Box, or a "Find record" against a list box.

Has anyone run into this issue, and if so, was there a way to work around it?

Thank you,

T.J.

 

[Sergeant]

Please, anyone, correct me if I'm wrong...A combo box is a combination of a text box and a list box. If you want to take advantage of the combo box's functionality, why do you still need a list box?
You can use the DropDown method of the combo box control in the form's open or current event, and it will act like a listbox until you click on a selection.

 

[TJBernard]

Please, anyone, correct me if I'm wrong...A combo box is a combination of a text box and a list box. If you want to take advantage of the combo box's functionality, why do you still need a list box?
You can use the DropDown method of the combo box control in the form's open or current event, and it will act like a listbox until you click on a selection.

You are correct. The users just wanted a list box originally, so they could see a few columns of information for each row (and yes this can be added to a drop down combo box as well). The users liked the look of the list box, so I was just trying to find a way to make it work.

If nothing else works, I will then go back to them and tell them you either get a list box, or you get a drop down combo box.