Updating the Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

My questions is how do you update a report (show all the fields that have
been entered into a form) before the record has been saved?

I have set up a report that takes information from a form. When the user has
finished entering the information in the form, I created a cmd button that
summarizes the information they just entered. But when the user uses this
button, the report does not show the data that was entered.

I have noticed that the report works fine once the user has either closed
out of the record or moved on to another record. From what I can guess is
that the form does not save/update the information into the table until the
user has moved into a new record.

I tried using the save function, but it didn't work either.

Thank you in advance

C
 
I'm not sure what "save function" you used but you must save the record
prior to running the report.

Also keep in mind that forms don't store information, they are used as a
window to display records.
 
Got it. So I would have to create a save funtion using VBA in the cmdButton.
I am not very good with VBA, is there another way to save the record without
exiting the form?
 
If you have a cmdButton with code that prints the report, you can add a line
prior to the OpenReport like:
DoCmd.RunCommand acCmdSaveRecord
 
Back
Top