Melissa,
As long as the data you've just entered has been saved to the table, a
report based on that table will show the latest values.
This problem usually occurs when someone edits a record via a form, and
runs a report without actually "posting" the new data to the table
If you run a report right from the form you just edited, try a "Refresh"
before running the report. Then you know the data you just entered has been
saved to the table.
Refresh
DoCmd.OpenReport "rptYourReport"
hth
Al Camp