Solved

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

Posted on 2009-04-12
5
201 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
ID: 24126734
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
ID: 24127203
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
ID: 24128833
You would usse this just before you requery:

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

Author Comment

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

Best regards

Terry
0
 

Author Closing Comment

by:TerenceHewett
ID: 31569354
Sorry LSM, thought I had accepted this solution.  

Best regards
Terry
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

832 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