Report View

[Rosalene Ribot]

I am having a problem viewing new data that is entered in
a form on a report. All the other entries are viewable,
but the new entries are not. I have tried grouping and
sorting the date field in the report design, but still
cannot view the current entries.

 

[Fredg]

Rosalene,
You have probably just entered the data and clicked a command button to view
the report.
Access does not save new data until you go to the next record, close the
form, or explicitly tell it to save the data.

Add a line of code to your command button click event:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", acViewPreview

 

[Fredg]

Rosalene,
One way to manually save the data is to click on
the Record Selector bar (on the left side of the Form).
Or navigate to the next record.
Or simply close the form,.

How are you opening the report anyway?

And are you using a Date field as criteria in the report?
If so, are you entering the date and the time in the field?
If the date and time are entered, then you must have the criteria end on the
day after you really want, as records entered on 6/25/2003 are not the same
as records entered on 6/25/2003 01:00 A.M. The later record will not be
returned if the criteia simply calls for 6/25/2003.
So enter 6/26/2003 to return all 6/25/2003 records.