Listbox Code

[Guest]

I am trying to select an option in a listbox. Then when I click a command
button, I would like to use the field that was selected in the listbox. How
do i do this?

 

[John Vinson]

I am trying to select an option in a listbox. Then when I click a command
button, I would like to use the field that was selected in the listbox. How
do i do this?

Put code in the AfterUpdate event of the listbox.

What is the listbox's RowSource? What are the "options" and what are
the "fields"? Normally a listbox will have a value in its bound
column, containing the value of some field from its row source query.

John W. Vinson[MVP]