When I am on the first record on the list and I open the form to delete that record, when closing the form I get Error Number: 3159--not a valid bookmark. Below is the code I am using:
Dim bkMark As String
If CurrentProject.AllForms("frmViewEventHistoryList").IsLoaded Then
bkMark = Forms!frmViewEventHistoryList.Bookmark
Forms!frmViewEventHistoryList.Requery
Forms!frmViewEventHistoryList.Bookmark = bkMark
End If
Is there a way I can tell it to go to next record if I delete the record I selected?
Dim bkMark As String
If CurrentProject.AllForms("frmViewEventHistoryList").IsLoaded Then
bkMark = Forms!frmViewEventHistoryList.Bookmark
Forms!frmViewEventHistoryList.Requery
Forms!frmViewEventHistoryList.Bookmark = bkMark
End If
Is there a way I can tell it to go to next record if I delete the record I selected?