Write Name of Report Query in Report Footer

  • Thread starter Thread starter Steve Stad
  • Start date Start date
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.
 
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.

Place a text box on your report, and set its Control Source property to:
=[Report].[RecordSource]
 
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.

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.

.
 
Back
Top