how to print a nonbound column from a combo box on my form

[rbemiller]

I'm trying to get a certain field from my form to print out on my report. On the form, the field in question is a combo box which actually looks up 3 seperate columns from a db. When I reference the combo box to be printed on my report, the bound field of the combo box is what prints out on the report. However I need one of the other of the three fields to be printed.

Currently, the control source for this field on my report is:

=[Forms]![frmRcv]![cboRevSelect]

Is there some way to edit the above code to get the specific field I need from the combo box?

the name of the field I need to be printed is frev

Any ideas?

 

[Rich]

=[Forms]![frmRcv]![cboRevSelect].[Column] (2) which is the third column

 

[rbemiller]

Thanks Rich, that did it!