List Box Values.

[Sprawl]

I'm so full of questions today!

I have a form with multiple list boxes. you select a value from one and the form further populates another, and so on and so forth (there are actually 7 of them!!!!). They work great for giving a nice dirty list of data when you want it too.

However, one of my list boxes has 3 values. date1, Date2, and date3. Clickin this one launches a new form window.

thsi new form has 3 subforms that all run 3 different queries for their data. and guess what. All different forms queries require the different dates. Page1 requires Date1, Page2 requires Date2 and Page3 requires Date3.

so the question is. Is there anyways to reference more than 1 column in a listbox?

 

[boblarson]

To reference other columns in listboxes and comboboxes:

Whatever = Me.YourListBoxNameHere.Column(1)

That would reference the 2nd column (they are zero based).

 

[rainman89]

as far as i know you can reference them one at a time.

list.column