How do i set up a macro that will repeat automatically?

[Guest]

I want to display an Access query on a big screen and have it automatically
update the query every 5-10 minutes.

 

[Steve Schapel]

Mike,

I would suggest using a continuous view form bound to the query, and
show your data here. You can set the Timer Interval property to the
required value (milliseconds, so you would enter 300000 for 5 minutes).
And then make a macro with the Requery action (leave the Control Name
agrument blank), and assign the macro on the On Timer event property of
the form.