Requery if form has focus (1 Viewer)

[tacieslik]

How can I run a .Requery event only if my form has focus?

I currently run an OnTimer event to do the following:


Private Sub Form_Timer()

Forms!frmMAIN.Requery

End Sub


I want to only do the requery if the form actually has the focus.

TIA

 

[tacieslik]

In addition to the above, I still need to use the timer event, but only when the form has focus.

 

[Dugantrain]

There is a form-level GotFocus event. If that doesn't trigger when you need, then the Activate event probably will.

 

[tacieslik]

Thanks Dugantrain, I've sorted this out.

 

[Mile-O]

Just to add that a form's GotFocus event will only execute if there is no control on the form that can receive the focus.

 

[tacieslik]

Thanks Mile-O-Phile, I think it was you that told me that in another post. Cheers.