Printing Combo Box on Report

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

Guest

I apologize for the earlier bad posting. I am used to the old form and put my email address as the subject.

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 apologize for the earlier bad posting. I am used to the old form and put my email address as the subject.

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...

Did you put an equal sign before the Forms. E.g.:

ControlSource: =forms!formname!cboRoomUse.column(0)

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Put a breakpoint in the report's Open event & when the pause occurs,
in the immediate window type:

? forms!formname!cboRoomUse.column(0)

(remembering to change the form name) to see if anything is actually
being returned by the combo box. Remember, the form that holds the
combo box must be open (and, I believe, it cannot be in dialog mode).

Only other thing I can think of is you've misspelled something in the
form reference (form name or control name).

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBBICIechKqOuFEgEQLnLACghbSIA3ib9kGeAL1z2OmK6d+VKvgAn1VH
RvwVsMefZ5CfXeJTkC2m/mDi
=XzmO
-----END PGP SIGNATURE-----
 
Back
Top