Access asking for extra data in reports.

A

Amanda

I have a report which keeps prompting me to enter data which used to be in
the report but I have since deleted....how can I get it to stop asking me for
this data?
 
M

Maurice

There could be a filter set in the properties of the report. Check to see if
no filter is set. Furthermore you can have some calculated fields or
referring fields to non-existing fields (so check the fields on your report
to see if there are any refs)

Finally if you have any subtotals done with the previous data see if the
total fields are deleted...

Just my thoughts...

hth
 
J

Jerry Whittle

Hi,

Did you delete the fields that use to hold the data or just hide them? If
they are still there, you'll get prompted.

Were any of those fields used in calculations for other fields? You'd think
that you'd get #Error or #Name errors though.

My best guess is that you use to sort and group on some of those fields.
Check the sorting and grouping options for the report to see if any of the
old stuff is asked for there.
 
A

Allen Browne

As well as checking in the Control Source of all the controls on the report,
look in the Sorting And Grouping dialog, and in the report's Filter and
OrderBy properties. Also check the RecordSource of the report, e.g. it could
be in the underlying query.

If you can't find it, you may be able to locate it programmatically using
the code in this article:
Where is a field used? - Search tables, queries, forms, and reports for
a field name
at:
http://allenbrowne.com/ser-73.html#FindInFormReport
 
Top