HELP Referencing Columns in a List Box

[PorscheMan]

I have a List Box with two columns. Column 1 is bound. In a query, I am referencing the List Box as the criteria. [Forms]![frmSelect]!


[List0]. I am able to retrieve the expected data from Column 1. I would like to use Column 2 in another query. How do I reference Column 2 in my List Box? [Forms]![frmSelect]!
[List0]! ??????

Any help appreciated. Thanks

[ssanfu]

Try:

[Forms]![frmSelect]!
[List0].Column(1)

(the column property is zero based)

[PorscheMan]

[Forms]![frmSelect]!
[List0].Column(1) did not work

I get an error message Undefined function '[Forms]![frmSelect]!
[List0].Column' in expression

I tried bracketing [Column(1)] and removing the parenthesis around the number 1 - no such luck.

[ssanfu]

Sorry..
I missed the fact that you were using a query. I can't get the ".Column(1)" to work either.

Here is a work around.
Add an unbound text box on the form "frmSelect".
In the after update event of "List0", add

Private Sub List0_AfterUpdate()
  Me.Text2 = Me.List0.Column(1)
End Sub

Change "Text2" to your text box name.

In the query criteria, enter

[Forms]![frmSelect].[Text2]

(again, change Text2 to your text box name)


Another work around would be to create the SQL for the query in code and update the SQL property of the saved query.

[PorscheMan]

I will use the work around as it seems the easiest way. Thanks again for the help.