Query that refreshes automatically

[bluedigital]

I have a database where students use a Form to sign in for computer help. I would like to have a queue displayed on another screen that shows the students what position they are in for help. How would I go about doing that? I thought that having a query on a seperate screen (with no keyboard lol) would be a good way of displaying the student's order, provided I can get a query screen to update automatically or refresh say every 30 seconds. Is this possible, or am I way off base?

 

[rainman89]

its possible there is a timer event on a form that you can set to requery

 

[bluedigital]

So the requery option would be on the Query, or the Form? I'm not sure I understand. Could you tell me briefly how to go about setting that?

 

[rainman89]

take a look at this
http://www.blueclaw-db.com/access_event_programming/timer.htm