Why is it that when I call recordCount on a rescordset it returns 1 even when I know that there is two different records in it and able to access those two records in the set.
Talguy
0
Junior Poster in Training
Recommended Answers
Jump to PostBecause the cursor type you have chosen only knows about the first record, the record it sits on. To fix, do a movelast, movefirst and this will tell your cursor type how many records are in the recordset...
Good Luck
All 2 Replies
vb5prgrmr
143
Posting Virtuoso
Because the cursor type you have chosen only knows about the first record, the record it sits on. To fix, do a movelast, movefirst and this will tell your cursor type how many records are in the recordset...
Good Luck
Talguy
0
Junior Poster in Training
Thanks that worked
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.