Show 2nd column value in cbox instead of 1st?

[michaeljohannes]

Hello,

Quick question:

Can someone suggest a bit of code that will show the 2nd column from a combo box in a report rather than the first?

I have used the following code in a form, but it doesn't work the same in a report...

Me.MyReportControl_detail = Me!MyReportControl.Column(1)

Basically I have a drop down control that shows a letter, and its description. But on the report, I would like to show the description and not the letter (ie the letter is meaningless without the description).

As I said, the code works using an unbound text box on a form, but doesn't work the same in a report. I think my syntax is incorrect.

Any suggestions?

Thanks!
Mike

 

[boblarson]

Combos aren't used on reports. You can reference a combo from a form on a report:

Me.YourTextBoxOnReport = Forms!YourFormName.YourComboName.Column(1)

 

[michaeljohannes]

Hey Bob,

Sorry, i'm an idiot... I figured it out just after I posted it! My SQL statement was incorrect.

Cheers,
Mike