Using second column in a combo box

[UT227]

I'm trying to bring over information from a combo box from another form. I need the information from the second column. Here's the default value I put: =IIf(IsNull([Forms]![frmStatisticAnalysis]![cboCampusID]),"All Campuses",[Forms]![frmStatisticAnalysis]![cboCampusID])

I'm trying to get the information from the second column in combo box [cboCampusID] in [Forms]![frmStatisticAnalysis]![cboCampusID]

[June7]

Reference the column index. Index begins with 0. Second column has index 1.

[cboCampusID].Column(1)

You put this in DefaultValue property?

[UT227]

Yes. I put it in the default value. I didn't have anywhere on my query to pull the information from. I had to use my search form as the default values for the form's title. It's not the way I wanted to handle it, but it solved a problem that I have been working on for a while now.

Thanks a lot. That worked like a charm.