I built a sign-in tool for my office. When the customers sign in the program reverts to a main form that has some generic info an a list box that lists all the customers waiting to be served.
I want the form to refresh itself every 15 seconds. What I've done on other forms is simply place a requery statement in the Timer Event and then specify the timer interval; however, this doesn't work on the form I built because the List Box is based on another query.
Since the list box doesn't have a timer event, how do I requery the form/list box? Any help would be appreciated.
I want the form to refresh itself every 15 seconds. What I've done on other forms is simply place a requery statement in the Timer Event and then specify the timer interval; however, this doesn't work on the form I built because the List Box is based on another query.
Since the list box doesn't have a timer event, how do I requery the form/list box? Any help would be appreciated.
