Set Caption Of Label On Report

[Steve]

I have a button on a form that opens a report. I need to set the caption of
several labels on the report equal to the value of a columns in comboboxes on
the form something like:

LabelOnReport.Caption = ComboboxOnForm(2)

Where the boundcolumn of the combobox is 1.

I keep getting an error message no matter what I try. How is this done?

Thanks!

Steve

[Fredg]

In the report's Report Header event...
If the Combo column wanted is the bound column:

LabelName.Caption = forms!FormName!ComboName

If the column wanted is NOT the bound column:

LabelName.Caption = forms!FormName!ComboName.Column(1)

Combo boxes are Zero based, so column(1) is the 2nd column.
The form must be open when the report is run
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Steve" <ss****@bellsouth.net> wrote in message
news:0P*****************@newsread1.news.atl.earthl ink.net...

I have a button on a form that opens a report. I need to set the caption of several labels on the report equal to the value of a columns in comboboxes on the form something like:

LabelOnReport.Caption = ComboboxOnForm(2)

Where the boundcolumn of the combobox is 1.

I keep getting an error message no matter what I try. How is this done?

Thanks!

Steve