Refresh reports on "Dashboard" form

[Integrate]

I have set up a type of dashboard by adding reports to a form that stays open. Links from the form are used to navigate to other forms/reports in the database. The user exits these subsequent forms/reports and returns to the dashboard.

I am trying to get the reports on the dashboard to refresh each time the user returns. I have tried adding a me.requery and me.refresh for each control to the form On Got Focus and Form Current events but this hasn't worked.

The system is very slow so I don't want to slow the database down by putting a refresh interval event on the form.
Is there any way I can get these reports to refresh when the user returns to the dashboard?

 

[moke123]

try the forms onActivate event and only requery those controls which are necessary.

Private Sub Form_Activate()

    Me.YourReportName.Requery

End Sub

when the dashboard becomes the active form(by returning to it) it should fire the event and code.

 

[Integrate]

Perfect, thank you very much