Find the table/query which pass into the report

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

There is a form where it ask the two dates and then run a query then
report.

Private Sub Command36_Click()
DoCmd.OpenQuery "qryResultsReport"
DoCmd.OpenReport "rpt_TopTen", acPreview, "", ""
end sub


qryResultsReport
SELECT tblCallSummary.* INTO tblResults
FROM tblCallSummary
WHERE (((tblCallSummary.[Date/Time]) Between
[forms]![MainMenu]![txtStartDate] And
[forms]![MainMenu]![txtEndDate]+1));

When i open the report rpt_TopTen the values which pass into the report
is totall different the values which are in that table. How to i know
the name of the table/query from where the values are comming into the
report. I am trying to find the name of table/query but i dont know how
to i find the source. For example when i click on the properties of one
textbox it shows some thing like that in the control source:

=Sum([Connecticut])

Another textbox control source shows some thing like that:
=[CombinedCountOfCallID]/Sum([CombinedCountOfCallID])

None of these variables are found in the table. I need help how to I
know the name of their table or query from where the values pass into
the report.


Thank You
 
How to i know
the name of the table/query from where the values are comming into the
report.
Click to expand...

Open the Report in design view; view its Properties (one way is to
rightclick the little square at the upper left intersection of the
rulers and select Properties). The Form's Recordsource property is
what you're looking for.

John W. Vinson[MVP]
 
Back
Top