Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO
Message
From
17/09/2001 16:49:46
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
ADO
Miscellaneous
Thread ID:
00557505
Message ID:
00557505
Views:
40
Hello,

I am having a minor problem with an ADO recordset. I have a form with navigation buttons on it(previous and Next). When I click on of these buttons from the first or last record in the recordset, all the linked controls on my form go blank. This would indicate to me that for some reason there is a blank record in the recordset, though I don't know why. Has anyone else had the same problem? What can I do to avoid this? I have included the code for the next button below....

Here's the code:
....If objRS.EOF() Then
If Me.NavMessage = True Then
response = MsgBox("This is the last record.", vbOKOnly, Me.Title)
objRS.MoveLast
End If
Else
objRS.MoveNext
End If.....
Thanks

Jim
Next
Reply
Map
View

Click here to load this message in the networking platform