List Box, need list.value(selected value) in a query. 1

[elevator]

I have a list box on my form with three choices.

Choice
-------
One
Two <-------- I chose Two, so it is highlighted.
Three
-------
When I click on either One, Two or Three it lights up
and the object explorer, properties, list.value box
indicates which choice is highlighted.

How do I get the list.value from the listbox to a string?

Var
Choice String
endVar

Q1= Query
IceCream.db | Scoops |
| ~Choice |
endQuery

 

[footpad]

Elevator,

You need to grab the Value proprty of the field object containing the list box, e.g:

   choice = field1.Value

If that doesn't work, then name the list object and the use:

   choice = field1.ListName.List.Value

Hope this helps...

-- Lance