Report Name

A

Andrew C

Hi

I have a combo box on the form that when you slecect a
name out of the combo box it loads the report relating to
that name. The only thing is i want to put a name at the
top of the report to show what the name is. And i need it
to update everytime the report is run to the new name.

Thanks

Andrew
 
A

Allen Browne

You can display the name of the report with a text box that has this
controlsource:
=[Report].[Name]

If necessary, you can also refer to the value of the combo on your form by
setting the ControlSource of your report text box to something like this:
=[Forms].[Form1].[Combo1]
or for the 2nd column of the combo:
=[Forms].[Form1].[Combo1].Column(1)
 
G

Guest

Thanks Alot

-----Original Message-----
You can display the name of the report with a text box that has this
controlsource:
=[Report].[Name]

If necessary, you can also refer to the value of the combo on your form by
setting the ControlSource of your report text box to something like this:
=[Forms].[Form1].[Combo1]
or for the 2nd column of the combo:
=[Forms].[Form1].[Combo1].Column(1)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a combo box on the form that when you slecect a
name out of the combo box it loads the report relating to
that name. The only thing is i want to put a name at the
top of the report to show what the name is. And i need it
to update everytime the report is run to the new name.

Thanks

Andrew
Click to expand...


.
Click to expand...
 
Top