Report not picking up data from an existing Access 2000 Table

  • Thread starter Thread starter Edward Grant
  • Start date Start date
E

Edward Grant

I am testing a database that uses aTabel used to store
information on sales leads. Having created a report to
summarize the lead information for a series of stsff, It
does not connect to the stored data even though the
controls to accomplish this are in place. I've read and
tiried most the things available in "Help' and else where
on the website, they don't seem to be effective. Any
suggestions???
 
Hi Edward,

is it possible that you give us more detailed information how you try to achieve this.
 
The first thing I would check is the RecordSource of the
Report. Open the DatasheetView of the RecordSource by
itself and see if it is the data you want.

If it isn't, you need to fix the RecordSource.

If it is, check the Filter Property of the Report. If you
open the Report by code, check the statement that opens
the Report for Filter or WhereCodition.

Note: If you are in the process of entering the data and
you want to include the new Record / or Record currently
being edited, you need to save it into the Table first
before running the Report.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top