Refresh/Requry/Repaint Form with SubReport/SubForm

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.

Todd

Answer 1

The form is not linked to a recordset

Hi Todd,

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

Imb.

Answer 2

So what happened when you tried to requery using the OnTimer event?

-Bruce

Answer 3

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