Where condition from 2nd column of a list 1

[PikPim]

Hi, I'm trying to put a query that would be based on the second row of a list and I don't know how to do it! The farther i can go with the expression generator is like:
Forms![Partners]![lstUsers]
but i would like it to be somethin like:
Forms![Partners]![lstUsers].firstname
(where firstname is the 2nd column of the list...)

 

[Ed2020]

Try:

Forms![Partners]![lstUsers].Columns(1)

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

BTW - It's Columns(1) rather than Columns(2) because the columns property of a listbox indexes from 0, not 1.

Ed Metcalfe.

Please do not feed the trolls.....