Refresh Form

[aldeb]

I have approximately 20 people using a shared database form. When someone updates a form creating a new record I want everyone to be able to see that new form record without having to close the form down and reopening it. Each form is given a form number by autonumber.

Thanks in advance!

 

[Mod]

You could put a hidden timer on the form that requery's every 10 seconds or so... Thats the best I can think of.

 

[aldeb]

Being fairly new to much of this especially timers, how would I do this and what do I requery?

Thanks again

 

[Mod]

errr, good question. I assumed VBA would have some sort of timer control, but I don't see it in my version. If you don't have it either, google for something like "timer ocx" and register it under "tools->active x".