Mar 20, 2001 #1 Larshg Programmer Mar 1, 2001 187 DK I have a subform that consist of a table and I want to update it evry 10 min. This should be done using some form of trigger or timer, the importent thing is the user doesn't have to do anything
I have a subform that consist of a table and I want to update it evry 10 min. This should be done using some form of trigger or timer, the importent thing is the user doesn't have to do anything
Mar 20, 2001 #2 ghubbell Programmer Feb 21, 2001 1,052 CA Hello Larshg, Type in to the Timer Interval Property field: 600000 (Thats 1000/sec x 60sec x 10 minutes. In your subforms on timer event (event procedure) then "..." in to VB add this: DoCmd.Refresh Should work! Gord ghubbell@total.net Upvote 0 Downvote
Hello Larshg, Type in to the Timer Interval Property field: 600000 (Thats 1000/sec x 60sec x 10 minutes. In your subforms on timer event (event procedure) then "..." in to VB add this: DoCmd.Refresh Should work! Gord ghubbell@total.net