422,764 Members | 1,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,764 IT Pros & Developers. It's quick & easy.

Report will not update when you enter in new data until you close and reopen form?

anoble1
100+
P: 214
Guys,
I am having an issue where when I enter in data into my form then click on my report button which runs a query it will not show the new total amount on the report until I close the form I was in and go back into it.

I have 3 textboxes that do that on this form. When you edit them it shows the new value on the form but when you open the report it still has the old until you close and reopen the form.

Ideas? Is there a refresh I can do before the report opens?
Oct 12 '17 #1
Share this Question
Share on Google+
1 Reply


PhilOfWalton
Expert 100+
P: 1,116
Don't forget that until you change records on a form, the data isn't saved.

There a few ways to overcome this:
My preferred method is on the button that opens the report, before opening the report add
Expand|Select|Wrap|Line Numbers
  1.      DoCmd.RunCommand acCmdSaveRecord
  2.  

As an alternative, you can use

Expand|Select|Wrap|Line Numbers
  1.      Me.Dirty = False
  2.  
Phil
Oct 12 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.