list box

  • Thread starter Thread starter n6trf
  • Start date Start date
N

n6trf

Ok had the wizard create a list box with entries from a table. One of the
questions it asked was where do I want the results? I said save it (but not
in the database). So how do I find out where the results of the operator
action is stored. I need to get that for a vba program. I get so frustrated
trying to find out anything from help. Guess I do not know where/how to
search :-(. I get old too quick & smart too late.
 
Hello n6trf and kc6rue.

n6trf said:
Ok had the wizard create a list box with entries from a table.
One of the questions it asked was where do I want the results?
I said save it (but not in the database). So how do I find out
where the results of the operator action is stored. I need to
get that for a vba program. I get so frustrated trying to find
out anything from help. Guess I do not know where/how to search
:-(. I get old too quick & smart too late.
Click to expand...

If the wizard created the listbox, you likely can only select one
single row in the litbox.
There are no "results" but there is a selected value. This value
will not be stored in the database but just in the control.
The value is the value of the "bound column" uf the selected row.
You can access that value through VBA using a syntax like this:
Me.NameOfThatListbox
provided that the code resides in the same form as the listbox.
 
Back
Top