Automatic refresh every 5 seconds possible?

[Gary]

I have a datasheet which is a subform on a form,
my database is going to be used by about 10 users, so i need to make
sure the data is constantly uptodate.

how do i refresh the form's data in my datasheet every 5 seconds?

thanks,

gary.

 

[RuralGuy]

Every form in Access has an OnTimer event and a TimerInterval. Set them up to
do the work for you.

I have a datasheet which is a subform on a form,
my database is going to be used by about 10 users, so i need to make
sure the data is constantly uptodate.

how do i refresh the form's data in my datasheet every 5 seconds?

thanks,

gary.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.