I assume the query stays open and you want it refreshed without closing. I
don't think this is possible. However, you could/should open a form to
display your records and set code in the Timer event to requery the form.
-- [toz] --
Duane Hookom
MS Access MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.