Hi,
I am working on a business tool for my team to solve communication issues. Using Access, I created a database, and am using a split form view. The purpose of the split form is to have one end of the team enter update their records, and have the other team view the results on the datasheet view (and visa versa), and quickly make their own changes in response to the feedback.
The issue I am running into is that the timer I set up to requery every 30sec interferes when users are inputting data into the spreadsheet, and leads the user back to the first record post-requery.
Code:Private Sub Form_Load()
Code:Me.TimerInterval = 30000 End SubPrivate Sub Form_OnTimer() Me.Form.Requery Me.Refresh End Sub
My ideal solution is where the records are requeried, but does not affect the user when in the process of updating records on either end of the shared network database.