I am trying to display a message box to the user when there are no more records in the recordset. I cant get the message to display. I have tryed several different ways.
If rs.BOF = True And rs.EOF = True Then
MsgBox "You are Currently at the Last Record!..", vbExclamation, _
"End of Recordset Error"
Exit Sub
ElseIf Not rs.EOF = True And Not rs.BOF = True Then
rs.MoveNext
End If
Thanks in advance
If rs.BOF = True And rs.EOF = True Then
MsgBox "You are Currently at the Last Record!..", vbExclamation, _
"End of Recordset Error"
Exit Sub
ElseIf Not rs.EOF = True And Not rs.BOF = True Then
rs.MoveNext
End If
Thanks in advance