Show a Table Name in a Report

[steve229922]

Is there a function that will show the table name that a report is built on? I built a report, and I want to show the source of the info in the header, much like the funtion =today() only I want the name of the table used to build it to be visible........

Any help appreciated!!!!

Thanks in advance---

 

[flyover789]

on your report header, create a labelfield, let's name it lbl_source.

in the on open event of the report add this code:

Private Sub Report_Open(Cancel As Integer)
Me.lbl_source.Caption = Me.RecordSource
End Sub

HTH,
fly



[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com