?
Solved

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

Posted on 2009-04-12
5
Medium Priority
?
216 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 85
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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

589 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