View Single Post
  #2  
Old May 24th, 2010, 02:55 PM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default Write Name of Report Query in Report Footer

"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.