Refresh/Requry/Repaint Form with SubReport/SubForm RRS feed

  • Question

  • I have a form which hosts multiple subreports which display the results of multiple queries aggregate functions in one place.

    Due to regular multiple user entry the data displayed in the form needs to be requirried on a time interval basis.

    I have attempted to set this up using the Timer Interval settings and on Timer Requery Form macro.

    The form is not linked to a recordset

    Thanks for the help in advance.


    Tuesday, August 16, 2016 8:25 AM

All replies

  • The form is not linked to a recordset

    Hi Todd,

    You could try to close the form, and re-open it.


    Tuesday, August 16, 2016 11:22 AM
  • So what happened when you tried to requery using the OnTimer event?


    Tuesday, August 16, 2016 2:34 PM
  • What exactly have you tried, and what was the outcome?  Were there errors, or did it just not seem to work?

    You could do this either from the Timer event of the main form -- requerying each of the subforms (or are they really subreports, as you said?) in turn -- or you could use the individual Timer events of each of the subforms.

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Tuesday, August 16, 2016 3:01 PM