Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data source

Status
Not open for further replies.

wdisneymom

Technical User
Feb 1, 2005
7
US
When I go into a report I would like to see what the report is based on, (query, table etc.)
What is the best way to do this
 
In design view or print preview?

Ed Metcalfe.

Please do not feed the trolls.....
 
Code:
Private Sub Report_Open(Cancel As Integer)
    MsgBox "RecordSource: " & Me.RecordSource
    Me.Caption = "RecordSource: " & Me.RecordSource
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top