UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> How do I get a report to refresh    
 
   
chippyles
post Jan 16 2006, 09:46 AM
Post #1

UtterAccess Addict
Posts: 136
How can I refresh or requery a report?

I have tried the following

docmd.requery
docmd.RunCommand acCmdRefresh
docmd.RunCommand acCmdSaveRecord

I have tried Shift F9 with no luck.

None of these work.
Go to the top of the page
 
+
AQM_UK
post Jan 16 2006, 02:35 PM
Post #2

UtterAccess VIP
Posts: 4,447
From: Suffolk, England
I think the answer is you can not as they are static and not dynamic. They represent data at the time you took the snapshot. You have to close and reopen the report.

I only use a report when the user needs to get a "hardcopy" electronically or otherwise. If I want a more dynamic report where the user can do things and see the results I write these into a form and deliver it in a GUI. The report is not a GUI and can not be played with this way.

Hope this helps.

Jim
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 11:48 AM