Report on a refreshed table coming up blank

[Cam]

I build a summary table based on many other tables using VBA. Here are the
steps:
- Clear the table
- Insert records from source tables with calculated fields defaulted to 0
- Fill in calcuated field in the table
- Print Preview the report based on the table.

Problem: The report prints with the calculated fields still at 0. I look at
the table and fields are not 0. If I close the report and open it again
prints the correct data. It almost seems like a timing issue.
Help Please it is dirving me insane!!

 

[Larry Linson]

You must have a complex or unusual application to need to create a table
from which to report... shades of DOS Paradox...

Strangely, though I've worked on some moderately complex applications since
1993 when I began with Access, I've never had any situation where it was
necessary to build a table from which to print a report.

If you could clarify what you have, how it is stored, and what you are
trying to do with it, maybe someone could offer you a reasonable
suggestions.

In the meanwhile, make certain that you are explicitly closing the
Recordset... there may be system settings that are affecting whether you
write immediately or when the system "gets around to flushing the buffers"
and, if so, I can't be of much Help.

Larry Linson
Microsoft Access MVP