G
Guest
I have a minor problem I can not seem to solve.
here is the code i have for find next
Private Sub cmdNextChild1_Click()
On Error GoTo Err_cmdNextChild1_Click
DoCmd.GoToRecord , , acNext
Exit_cmdNextChild1_Click:
Exit Sub
Err_cmdNextChild1_Click:
DoCmd.GoToRecord , , acFirst
End Sub
this finds the next record, then loops back to the first record. However,
before it will back to the first record, it shows a blank record.
I would like to know if there is a way for the blank record not to show and
have it looped back to the first record?
Thanks in advance..
Lisa
here is the code i have for find next
Private Sub cmdNextChild1_Click()
On Error GoTo Err_cmdNextChild1_Click
DoCmd.GoToRecord , , acNext
Exit_cmdNextChild1_Click:
Exit Sub
Err_cmdNextChild1_Click:
DoCmd.GoToRecord , , acFirst
End Sub
this finds the next record, then loops back to the first record. However,
before it will back to the first record, it shows a blank record.
I would like to know if there is a way for the blank record not to show and
have it looped back to the first record?
Thanks in advance..
Lisa