Placing data from a form control into a Report Label...

[Sean Massey]

I'm trying to put together a series of "End of Year" reports for my real
estate database, and I have something that is baffling me. I want to
put the year that of the report on the page header.

The reports will be opened from a form. The user will select the year
they want from the combo box, click a command button, and when the
report opens, that year will be part of the title.

I tried using the following in a label control in the report header, but
it doesn't appear to be working.

="End of Year Closed Property Report for "&[Forms]![Year End
Reports]![cmbYear]


Is there a way to put the year in directly from the form, or do I have
to find a different way of doing things?

Thank you in advance.

 

[fredg]

I'm trying to put together a series of "End of Year" reports for my real
estate database, and I have something that is baffling me. I want to
put the year that of the report on the page header.

The reports will be opened from a form. The user will select the year
they want from the combo box, click a command button, and when the
report opens, that year will be part of the title.

I tried using the following in a label control in the report header, but
it doesn't appear to be working.

="End of Year Closed Property Report for "&[Forms]![Year End
Reports]![cmbYear]

Is there a way to put the year in directly from the form, or do I have
to find a different way of doing things?

Thank you in advance.

In a Label control?
Your expression is fine.
You need to use an unbound text control.
The form must be open when the report is run.
The Year must be the bound column of the combo box.

 

[Sean Massey]

I'm trying to put together a series of "End of Year" reports for my real
estate database, and I have something that is baffling me. I want to
put the year that of the report on the page header.

The reports will be opened from a form. The user will select the year
they want from the combo box, click a command button, and when the
report opens, that year will be part of the title.

I tried using the following in a label control in the report header, but
it doesn't appear to be working.

="End of Year Closed Property Report for "&[Forms]![Year End
Reports]![cmbYear]

Is there a way to put the year in directly from the form, or do I have
to find a different way of doing things?

Thank you in advance.

In a Label control?
Your expression is fine.
You need to use an unbound text control.
The form must be open when the report is run.
The Year must be the bound column of the combo box.

Worked great. Thank you!

Sean