Return table/ Query that a report is based on

[citychap26]

Hi Guys,

I need to return the query name or table a report uses as it's source using VBA code. I had it working taking the data from the Namemap property but this has stopped working.

Any ideas...

Cheers

SK

 

[snyperx3]

how are you wanting to return it?
As a text control on the report? a dialogbox?



-Pete

 

[Cloonalt]

If you're looking to display the recordsource name on the report put a label on your report and then refer to it in the on open event of the report:

Me.[labelname].Caption = Me.Report.RecordSource