Access 2016 How to update data in background form before current form closed.

[AccessUser2016]

Help,

I have a form that has a graphic with pump images. If I click on a pump it brings up a form with notes on the pump. If I enter a note when I close the form it will display a command button indicating a note for that pump. The question I have is when I close the form with the note, it causes the background form to update but it doesn't look smooth and seems awkward to the eye. What I want is either a loading screen to hide this form while the data updates or either not to see anything until it completely updates. I tried a loading screen that times out but the background form still appears for a brief second. I am currently using pop up forms and maximizing the main form. Thanks for your help in advance.

[NeoPa]

Hi AccessUser2016.

Welcome to Bytes.com.

I'm afraid I'm thoroughly bemused by your explanation of what it is you're doing - or trying to do. I get you have two Forms. I don't get the purpose of a second Form if the first already shows the notes, nor how the first can be updated if it doesn't. All very confusing from my perspective.

[AccessUser2016]

Hi NeoPa,
I'll try to explain it better the main form has images with no notes but a flag indicating a note. The second form (pop up) is brought up by clicking on a transparent command button to bring up information for that pump on the main form. When I close it the main form is in the background working to update all of the fields. When I close the second form it causes the main form to update but it doesn't look smooth and seems awkward to the eye. How do I fix this?

[NeoPa]

Ah. I think I'm starting to understand better.

The answer depends to a certain extent on whether or not you hide the original Form when you open the Notes Form.

However you do the Requery (IE. Wherever it's triggered from.) you should try to ensure that it's called prior to closing down the Notes Form. That way, even if the main Form is still visible at that point, the user won't notice it, or be distracted by it, so much.

Unlike Excel, there's no Application.ScreenUpdating property to use. If hiding the main Form isn't right for you I imagine all you can do is to ensure it happens before the user's focus is back on it. I'm not aware of anything else that could really help I'm afraid.