Navigate to a record in a listbox

[jackkent]

This seems like a very simple issue but I can't seem to find the correct code to accomplish what I want to do:

I would like to be able to navigate to the first instance of a given field in a listbox. My form includes labels A B C D ... If the user wants to navigate to the first instance of a given field in the listbox, say for example the word begins with "W" he/she would click on W. I would like to scroll to that first instance of "W" in the given field.

[ajetrumpet]

there are a couple of methods that work. try using

docmd.findrecord "listboxvalue"

that's not really a great method though because it's ambiguous. for minimal code though, it works fine. check out the syntax in the help menu. the arguments are there too, which it has plenty.

[jackkent]

Thank you for your response... I did see your solution however I have multiple values in the listbox. Is there a way to use the value in a specific field?

[ajetrumpet]

Thank you for your response... I did see your solution however I have multiple values in the listbox. Is there a way to use the value in a specific field?

you mean a specific row item?

me.listbox.column(columnNumber, RowNumber)

cols and rows are indexed at 0, so the first col =0, first row=0, etc, etc...

[jackkent]

Thanks... Got it working with your help.