T
thedanmp
I have a combo box in a form (that works correctly in the form) and when I
print my report based on text from the form, I want the selection from the
combo box to print in the report, however, it is showing the autonumber id
(column 0) in the report instead of my choice (column 1).
In report design, I changed the combo box to a text box, then entered the
following in the control source: Forms![Projects]![TM].BoundColumn(1)
(my form name is "Projects" and the combo box name is "Tm.") I also tried:
Forms![Projects]![TM].Column(1)
I'm just getting an output of #Name? on my report. Any help would be
greatly appreciated.
print my report based on text from the form, I want the selection from the
combo box to print in the report, however, it is showing the autonumber id
(column 0) in the report instead of my choice (column 1).
In report design, I changed the combo box to a text box, then entered the
following in the control source: Forms![Projects]![TM].BoundColumn(1)
(my form name is "Projects" and the combo box name is "Tm.") I also tried:
Forms![Projects]![TM].Column(1)
I'm just getting an output of #Name? on my report. Any help would be
greatly appreciated.