Member Avatar for Talguy

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.

  • 2 Contributors
  • 2 Replies
  • 89 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by Talguy
Member Avatar for vb5prgrmr

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

Member Avatar for Talguy

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.