By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Set Caption Of Label On Report

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.