Data refreshing

F

Fred's

Hi Folks,

I have a problem, which I hope to solve with your help!.

After doing data entry on my form, I open my report with a command
button. The problem is that I have to press F9 on my keyboard to
refresh the data before opening my report. Otherwise, the report
doesn't take the changed.
Why this is happening? And what will be the solution, so that my
report takes the changed automatically

Thanking you all in advance for your continuous support

Fred's
 
F

Fred's

Access doesn't save new data until you navigate to another record,
close the database, or expressly tell it to save the new data.
Code the button's click event:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "reportName" , etc.....
Click to expand...

Hi Fredg,

That seems to work, but at the same time that my report refresh, the
report print, why? and how to solve the problem

Fred's
 
Top