List Box

  • Thread starter Thread starter deodev
  • Start date Start date
D

deodev

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
 
I've had better luck using the contents of a form's control to populate a
textbox.

Consider changing the control-on-report to a textbox and setting its
ControlSource to something like (untested):

=Forms!frmFin!List22

By the way, if a listbox has only a single value, how is it a "list"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
Click to expand...

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
 
Back
Top