Write Name of Report Query in Report Footer

S

Steve Stad

Is it possible to programmatically write the name of the query the report is
based on in a text box in the report footer.
 
A

Allen Browne

Steve Stad said:
Is it possible to programmatically write the name of the query the report
is based on in a text box in the report footer.
Click to expand...

Place a text box on your report, and set its Control Source property to:
=[Report].[RecordSource]
 
S

Steve Stad

Thank you mate.

Allen Browne said:
Steve Stad said:
Is it possible to programmatically write the name of the query the report
is based on in a text box in the report footer.
Click to expand...

Place a text box on your report, and set its Control Source property to:
=[Report].[RecordSource]

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

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

.
Click to expand...
 
Top