Form not updating

  • Thread starter Thread starter shelley kline
  • Start date Start date
S

shelley kline

How come when another user is entering information into
the same table/form as I am - I am not able to see this
information unless I close and open my form again?

How can I get my form to update my information
automatically?
 
I am not aware of any broadcast feature in Access that would do this.
One way to accomplish this would be to add a timer control on the form and
use the timer event to run a sub that requeries the form. If you set the
timer interval to say 500 milliseconds you would get an almost immediate
effect without using to much network resources.
A simpler approach would be to add a command button to the form, that runs
this code Me.Requery
It would save you from closing and reopening the form.

Ragnar
 
Back
Top