PDA

Click to See Complete Forum and Search --> : Simple Access Question...


Dragev
Sep 29th, 2000, 06:05 AM
What's the deal with Access?

I have a table with 1024 records, and in Form_Load and Data1_Validate, I have:

Label1.Caption = Data1.Recordset.RecordCount

Guess what? Label1.caption is 0 or 1 when it starts...
However, when I click any of the buttons (next, last ...), the correct 1024 is displayed?

How do I get the RecordCount before I manually click first,prev,next,last?

D

Stevie
Sep 29th, 2000, 07:27 AM
You have to move to the last record to start with, so that the record count can be determined.

Dragev
Sep 29th, 2000, 07:57 AM
Ahhh...

Thank you so much!

Have a great weekend!

----
D
----