I am using an Access Project using SQL Server 2000 and am
having a difficult time getting accurate record counts of
large recordsets (over 1000 records). I use the following
script to populate a caption on a form but for those large
recordsets the count displayed varies.
Public Sub prcPostRecordCount()
Dim rst As ADODB.Recordset
Dim lngCount As Long
Set rst =
lngCount = IIf(rst.EOF, 0, rst.RecordCount)
Me.lblMessage.Caption = lngCount & " Item(s) Fit The
Set rst = Nothing
Is there a way to make the code wait until the recordset
is entirely populated before displaying the recordcount?
Thanks in advance,