K
Kathy G
Someone help me please. I have 2 forms. One is used for data entry of
student test information such as Start Time and End Time. The other form is
a pop up form for display only. It shows which students are currently
testing and how much time they have left in their respective testing session.
My popup form has an OnTimer event so that every 5 seconds it recalculates
the time remaining in each testers session (this part works fine). I need it
to also Requery by the same timer event to show newly arriving testers and to
remove the finished testers. I have tried running a macro with the timer
event so that the form is requeried to show additional testers and to remove
finished testers but it has not worked. I also tried running the code
Me.TestsInProgress.Requery in the On Timer event property and which did not
work. I then tried Forms!TestsInProgress.Requery which also did not work.
Any suggestions would be appreciated.
student test information such as Start Time and End Time. The other form is
a pop up form for display only. It shows which students are currently
testing and how much time they have left in their respective testing session.
My popup form has an OnTimer event so that every 5 seconds it recalculates
the time remaining in each testers session (this part works fine). I need it
to also Requery by the same timer event to show newly arriving testers and to
remove the finished testers. I have tried running a macro with the timer
event so that the form is requeried to show additional testers and to remove
finished testers but it has not worked. I also tried running the code
Me.TestsInProgress.Requery in the On Timer event property and which did not
work. I then tried Forms!TestsInProgress.Requery which also did not work.
Any suggestions would be appreciated.