How to tell what query an existing report is referencing?

  • Thread starter Thread starter KB
  • Start date Start date
From the interface:
1. Open the report in design view.
2. Open the Properties box (View menu).
3. On the Data tab, look at the RecordSource property of the report.

In code:
Dim strDoc As String
strDoc = "NameOfYourReportHere"
DoCmd.OpenReport strDoc, acViewDesign, WindowMode:=acHidden
Debug.Print Reports(strDoc).RecordSource
DoCmd.Close acReport, strDoc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report runs, but table it references doesn't exist? 2
How to pull up data from an existing select query 1
adding another query to an existing report 5
Calculating page/report sums using calculated data from subquery 6
New User - adding to an existing report 1
Report Won't Run - Query Is Too Complex 7
Change data source of existing report 1
Running Sum Changes when not visible 2

Back
Top