Refresh a form automatically but only after a period of inactivity

R

Richard Horne

Hi guys, I'm not sure if this is even possible but let me explain:

We have a telephone call log database split into a front and a back end. The
front end is on all computers on our network - about 10. Whenever any of us
answers the phone we log the details and select who the call was for.

We all then have an inbox form which shows the details of any calls taken by
any of the team. If I enter a call, it appears in whoever's inbox it was
intended on my copy of the database, but doesn't appear on anyone else's
until they do a manual refresh.

To counter this previously I set the form to refresh every 5 minutes,
however if the user happened to be in the middle of working in the phone log,
if the refresh occured, the record they're working on would either be
replaced by the first record in the query, or after some work - the cursor
would return to the first field in the form they were working on. Which
obviously was rather annoying.

So is it possible to get a form to refresh automatically after for example 1
minute of inactivity? That way it only refreshes automatically if the user is
not using the database. Or can anyone figure out a better way of resolving
this?
 
Top