Re: List Box

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Fri, 24 Apr 2009 09:07:01 -0700, deodev wrote:

Hi,
I have a List Box (List22) on a form (frmFin) that is populated with one
value. I would like to use this value on a Label (lblFin) in a report. The
form is open and I have a command button (cmdFinRpt) on the form to open the
report.

How can I populate the Label

What is the purpose of a List box with just one value?

Anyway, as long as the form is open while the report is run, you could
use, in the Report's Report Header Format event:

Me![lblFin].Caption = Forms!frmFin!List22

The above assumes the value displayed in the List box is the bound
column.

Or.. you could use an Unbound Text control in place of a label.
Set it's Control Source to:
=Forms!frmFin!List22

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Quantcast