Unable to replicate Refresh All quick access toolbar button in form

Question

I have a form with several subforms whose content is edited in separate forms, opened by command buttons.

When the data in those forms is updated, and the extra forms closed, naturally the main form needs to be refreshed before those changes can be seen. Clicking the Refresh All quick access toolbar button achieves this perfectly.

So I made a macro for the "got focus" event on the main form to refresh it, but it does nothing. I tried repaint and requery as well, applying the latter specifically to the subforms in question, and ran them out of vba instead of an access interface built macro too, none of these seem to solve the problem.

vba coding:

Private Sub Form_GotFocus()

Screen.ActiveForm.Requery
Screen.ActiveForm.Repaint
Screen.ActiveForm.Refresh
Me.sfmContact.Requery
Me.frmCustCert.Requery
Me.frmCustReq.Requery

End Sub

Annoying thing is that if I put this (or even just the macro or Screen.ActiveForm.Refresh) in the on click event of one of the controls it works fine. Just can't seem to make it work in any automatic events that don't require thought or clicks from the end user.

This question is sort of a dupe of Refresh button on an Access form but that question is over a year old, and has no accepted answer. So I've expanded on it.

Is it even running the code in GotFocus event? You might want to try the Form_Activate event instead — dbmitch
My guess is that it's not running it, but I don't know why. I got mixed up between OnActivate and OnLoad, which is why I didn't try that option. That works and solves the problem, but why wouldn't GotFocus fire? Surely the main form lost focus when another form got it for updating, and then it got it back again when the other form closed/anything in the main form was selected... — Isaac Reefman
Glad you got it working for you. Following VBA event progression is one of life's unpleasant tasks. — dbmitch

Jiggles32 Jiggles32 · Accepted Answer · 2018-04-26T21:30:05

What you mentioned in your comment there is correct:

My guess is that it's not running it, but I don't know why. I got mixed up between OnActivate and OnLoad, which is why I didn't try that option. That works and solves the problem, but why wouldn't GotFocus fire? Surely the main form lost focus when another form got it for updating, and then it got it back again when the other form closed/anything in the main form was selected...

To avoid this type of error in the future, it may be prudent to specifically name the form in your code instead of using the "Me." command, as that only works for current focus. For instance:

Me.sfmContact.Requery > Forms![FormName].sfmContact.Requery

Alternatively, you could just set the focus to the form in question before that sort of coding.

Forms![FormName].SetFocus

Unable to replicate Refresh All quick access toolbar button in form

1 Answers