Reference column in list box that is not the bound one

[wandan]

Hi there,

I have a list box that has name and userid as the two columns. The userid is my Bound Column because I use that in most of my queries and code. But, I have at least one case where I want to show the name selected -- like in a report header. Is there a way to reference the unbound column?

Thanks.

 

[PWise]

listboxname.column(1)
listbox column are zero based

 

[dhookom]

the name selected -- like in a report header

Don't you have the UserID so you can add the table with the User Name field(s) into the report's record source?

IMO, you shouldn't reference the control from the form in the report.

Duane
Hook'D on Access
MS Access MVP

 

[wandan]

Thanks for the reponses! listboxname.column(1) worked perfectly!!