missing last entry in my report (1 Viewer)

[deekras]

i have a form where i enter today's date for those who are entitled to commision checks. after i enter the date for all those, i click on a button to open a report. however, the report is missing 1 person's commision - always the last entry.

i imagine it is something simple. what am i doing wrong?

 

[pbaldy]

It sounds like you're running the report from the form where you're entering the data? I wonder if the last record entered hasn't been saved at the point when you run the report. If not, you could add:

DoCmd.RunCommand acCmdSaveRecord

to force it to save.