Hi,
I have a form to view the bible verses and i added the next code to automate moving to next record.
but,
when it reachs to last record it generates and error.
so,
i need to make the code stop when it reaches to last record
the code is:-
----------------------------------------------------------
Private Sub Form_Timer()
Form.TimerInterval = TheTimeInterval * 1000
If RunTimer.Value = True Then
DoCmd.GoToRecord , , acNext
End If
End Sub
----------------------------------------------------------
where "TheTimeInterval" is a combo box that contains values from
1 to 10 to control the speed of moving between records
thanks in advance
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar