Updating Form

  • Thread starter Thread starter Janelle
  • Start date Start date
J

Janelle

I have designed a form called reception that sort of acts
as a communication centre. I have my database split into
back/front end. I have maybe a dozen users who enter in
their daily appointments (in their own daily log screen)
and the receptionist will check off an arrived box (on
this reception form)as soon as they come in. This will
then sort of let my staff know that once the check is in
the box, their client has arrived. My question is this,
what is the most efficient way of updating this reception
form? I need to allow for people to change their daily
schedules at any given time, and have their changes
updated to the reception form (at least every 5 mins). I
also need the reception form to update once the
receptionist "checks in" the client. How do I go about
doing this? I use access 97

Thanks in advance
Janelle
 
Use the form's Timer() event to requery its data

Me.Requery

The timer event won't fire unless you also set the
TimerInterval property of the form. 1000 = 1 second, so
300,000 = 5 minutes. good luck.
 
Back
Top