Thread: Write Name of Report Query in Report Footer
View Single Post
  #3  
Old May 24th, 2010, 03:59 PM posted to microsoft.public.access.reports
Steve Stad
external usenet poster
  
Posts: 89
Default Write Name of Report Query in Report Footer
Thank you mate.

"Allen Browne" wrote:

"Steve Stad" wrote in message
...
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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

.