I have a code on a continuous form that I'm trying to get the Form_Timer function to GoTo a new record if the current record's TimeIn is 60 seconds less than the CurrentTime. So once the record has been sitting there for 60 seconds, based on the TimeIn then it moves to a new record and sets focus to OperID.
Here is my current VBA that is not working.
Private Sub Form_Timer()
If DateDiff("s", Me.TimeIn, Time()) > 60 Then
DoCmd.GoToRecord , , acNewRec