S Steve Stad May 24, 2010 #1 Is it possible to programmatically write the name of the query the report is based on in a text box in the report footer.
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 May 24, 2010 #2 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]
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 May 24, 2010 #3 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...
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...