[email protected]

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a combo box on it called cboRoomUse. When a user selects a item from the list, a report is generated. The combo box has 2 values in the box. I want to be able to bring over the information in the first column of the combo box
On the report I inserted a text box, and in the control source I entered forms!formname!cboRoomUse.column(0
When I run the report I get a message box wanting me to enter the value.
Obviously I did something wrong. Could anyone point me in the right direction?
 
Todd said:
I have a form with a combo box on it called cboRoomUse. When a user selects a item from the list, a report is generated. The combo box has 2 values in the box. I want to be able to bring over the information in the first column of the combo box.
On the report I inserted a text box, and in the control source I entered forms!formname!cboRoomUse.column(0)
When I run the report I get a message box wanting me to enter the value.
Obviously I did something wrong. Could anyone point me in the right direction?
Click to expand...


Assuming you used the real name of the form in place of
formname, the only thing I can think of is that you forgot
the = sign at the front of the reference. Oh yeah, the form
must remain open for the value to still exist.
 
Back
Top