Solved

How can I refresh a form without refreshing the subforms that are contained on it?

Posted on 2009-04-12
5
197 Views
Last Modified: 2013-11-28
Hi experts,

Is it possible to refresh a form without refreshing the subforms contained on it?  Basically, when I requery or refresh my form the subforms blink once as if they are refreshing.  I do not need this to happen as the subforms are only on there for extra information and not part of the same record, i.e. the subform information is static and the recordsource is from another table. Please could somebody help me to not refresh these subforms?  

At the moment, on my form that has the subforms on it, I click a button to refresh the data on the form, in effect this refresh saves the data to the table.  When I click this button the subforms blink as if they are updating, but this is not required.

I have tried both me.refresh and me.requiry but neither have stopped the subforms from blinking once.

Any help would be gratefully received. Thank you.

Regards,
Terry
0
Comment
Question by:TerenceHewett
  • 3
  • 2
5 Comments
 
LVL 84
Comment Utility
This is default behavior, and you really cannot tell Access to ignore the subforms. You can, however, "lock" the screen so it doesn't update until you tell it to. Use this:

In the General Declarations section of a standard Module (i.e. not a Form module):

Declare Function LockWindowUpdate Lib "user32" (ByVal hWnd As Long) As Long

Now, anywhere you need to turn screen updating off:

LockWindowUpdate Me.hwnd

To turn it back on:

LockWindowUpdate 0
0
 

Author Comment

by:TerenceHewett
Comment Utility
Thanks LSM for the code above.  I think this is exactly what I need but I have tried this code in the OnOpen, OnLoad, OnCurrent events of the form and I still have the same issue.  I did put the Declare... code into the General Declarations of a standard module.

Any ideas where this code should be executed?

Thank you again.

Terry
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
You would usse this just before you requery:

LockWindowUpdate Me.Hwnd
<do your requery>
UnlockWindowUpdate 0
0
 

Author Comment

by:TerenceHewett
Comment Utility
LSM, you are a genius - thank you very much - this has resolved my problem.

Best regards

Terry
0
 

Author Closing Comment

by:TerenceHewett
Comment Utility
Sorry LSM, thought I had accepted this solution.  

Best regards
Terry
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now