View Single Post
 
Old August 1st, 2008, 10:44 PM
ostrandernw ostrandernw is offline
Authorized User
 
Join Date: Nov 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Code Error Chapter 5

In chapter 5 pg. 167, the code reads:
'move to the next record in the local record since the
'current one is being deleted
If Not rsContacts.EOF Then
   rsContacts.MoveNext
  'save the id of the current (next) record
  intCurContact = rsContacts!intContactId
End If

but if you delete the last record in the recordset you get and error:
Runtime Error: 3021
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.

Any idea on how to correct this.
Thanks