Save NonBound column in a combo box

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

Lee T.

In my combo box I am bounding my ID field but displaying
the persons name. I would like to pass the NAME onto a
report so we know who the report is about (It is a pie
chart). I am not having any luck in figureing out how the
capture column 2 (the unbound but displayed column) from
my combo box.

tia

Lee T.
 
Lee said:
In my combo box I am bounding my ID field but displaying
the persons name. I would like to pass the NAME onto a
report so we know who the report is about (It is a pie
chart). I am not having any luck in figureing out how the
capture column 2 (the unbound but displayed column) from
my combo box.
Click to expand...


You can use the the combo box's Column property to reference
any column in the selected (or any other) row. The report
can use a text box with an expression like:

=Forms!theform.thecombobox.Column(1)
 
Marsh,

Thanks! That worked great.

Lee T.
-----Original Message-----



You can use the the combo box's Column property to reference
any column in the selected (or any other) row. The report
can use a text box with an expression like:

=Forms!theform.thecombobox.Column(1)
Click to expand...
 
Back
Top