There is a combo box on my form (let's say frmMain), when I open a report from that form I want a text box that goes along with that combo (let's say cboInfo). This is what I'm using in a text box on the report in the Control Source...
=[Forms!frmMain.cboInfo]
It returns the value just fine, but it returns the bound column value - which is column 1, a numeric identifier. The second column in the combo box is the text (ex: High, Medium, Low), I want this text on the report not the number. I've tried to put:
=[Forms!frmMain.cboInfo].Column(2) as the control source, but that doesn't work, or maybe I'm not doing it right.
Any thoughts??
=[Forms!frmMain.cboInfo]
It returns the value just fine, but it returns the bound column value - which is column 1, a numeric identifier. The second column in the combo box is the text (ex: High, Medium, Low), I want this text on the report not the number. I've tried to put:
=[Forms!frmMain.cboInfo].Column(2) as the control source, but that doesn't work, or maybe I'm not doing it right.
Any thoughts??