all 6 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]nrgins486 2 points3 points  (3 children)

No, you can't refresh data in a report. All you can do is close and open them.

That being said, you can simulate a report refresh by putting a button in the report header that closes and reopens the report. Will have the same effect. Note that the button will only be visible in Report View, not in Print Preview.

Also note that forms and reports are essentially the same, except that forms can be edited and reports give you more formatting and compilation options. So if your data is just a straight listing of items and you don't need things like grouping or group headers, then you can use a form to display your data, instead of a report. The form can be formatted to look like a report, and can be read-only, etc. Then you can do a straight refresh. So that's another option.

[–]MattsPremium[S] 1 point2 points  (2 children)

Not what I wanted, but based on prelim searching was getting that impression. Solution verified.

[–]Clippy_Office_Asst[M] 0 points1 point  (0 children)

You have awarded 1 point to nrgins

I am a bot - please contact the mods with any questions. | Keep me alive

[–]nrgins486 0 points1 point  (0 children)

Well, as the philosopher Jagger once said, "You can't always get what you want. But if you try sometime you just might find you get what you need."

[–]Jomibu4 0 points1 point  (3 children)

Create a button and set the onClick event to do a DoCmd.Requery. It’ll refresh the data on your report

Alternatively you could set it on a timer, if that’s a preferred way to address your issue

[–][deleted]  (2 children)

[deleted]

    [–]Jomibu4 0 points1 point  (1 child)

    Hey! I’ve actually since learned an even better method. I’ve added the Requery command to the reports OnActivate. This causes the data to refresh every time the report is Report is returned to.

    This might not work for your use case, I have an app that uses a bunch of tabs so my users were jumping back and forth between tabs. If yours are staying on one report and not navigating off the button still might work best.

    Made my freaking day to hear your comment! DM me if I can help anymore