How to get a report to refresh?

[Guest]

A report in my database will not refresh when I add new data to the
underlying table. Recreating the report, doesn't help either, the new data
is not included in the new report either. I've tested it very carefully,
just added one value, checked to see if the # of records increased, but it
did not.

Questions:
1. How to get the report to refresh with the new data?
2. How to get a new report to show the new data?

Any help you can give would be appreciated.

Richard

 

[Duane Hookom]

This probably is not an issue with the report. Check the Record Source of
the report to see if the records display as expected. My guess is there is a
data issue.

 

[Larry Linson]

A report in my database will not refresh when I add new data to the
underlying table. Recreating the report, doesn't help either, the new
data
is not included in the new report either. I've tested it very carefully,
just added one value, checked to see if the # of records increased, but it
did not.

A record added from a form will not be actually written to the Table until
you execute code to save it (DoCmd.RunCommand acSaveRecord, IIRC), press the
appropriate F-key, move to a different record, go from main Form to Form
embedded in a Subform Control (or vice-versa), or close the Form. Are you
certain you did one of these?

I think this may be one of the things that others had in mind when they said
"data issues."

Or, it could be that you have a WHERE clause in the Query that is
RecordSource for the Report that just doesn't select the new record (or
similar WhereCondition argument in a DoCmd.OpenReport).

Larry Linson
Microsoft Access MVP