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

[anoble1]

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?

[PhilOfWalton]

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

     DoCmd.RunCommand acCmdSaveRecord

As an alternative, you can use

     Me.Dirty = False

Phil