using timer and requery

M

Martin J

My db requeries in afterupdate using bookmark to keep my place. Then I put in
timerinterval=300000(5 minutes) in onload and in ontimer event ...

On Error GoTo errhand
Dim var As Variant
If Me.Dirty = False And Me.NewRecord = False Then RunCommand (acCmdSaveRecord)
var = Me.Bookmark
Me.Requery
Me.Bookmark = var
Exit Sub
errhand:
If Err = 3021 Then
Me.Requery
DoCmd.GoToRecord acDataForm, "myform", acNewRec
End If
End Sub

Sometimes when someone puts in a new record it goes to the beginning of
records why? And can I tell it to start timing again to 5 minutes on key
press or mouse click?

Martin
 
Top