Unbound Field

[Pass-the-reality]

I create an Unbound list box on my switchboard. Tied to the Unbound list box
is a query from another database. The list box is used as an alert system.
How can I set the list box to refresh automatically every 20 to 30 minutes?

 

[Arvin Meyer [MVP]]

Write your refresh code resetting the rowsource of the listbox, in the
Timer() event of the form. Set the timer interval for: 1200000 milliseconds.

 

[Klatuu]

Use the form's timer event. The timer intervial is in milliseconds, so 1000
= 1 second, so 1800000 would be 30 minutes
Then in the form's timer event:
Me.MyListBox.Requery