Count records in Form

[Lamar]

I have form that is based on a table. I need to store the
total number of records being displayed on the form into a
variable.

So if the table has 13 records then I need store that
value. How do you do that in VBA?

Thanks for any help.

 

[Jonathan Parminter]

-----Original Message-----

I have form that is based on a table. I need to store the
total number of records being displayed on the form into a
variable.

So if the table has 13 records then I need store that
value. How do you do that in VBA?

Thanks for any help.
.

Hi Lamar,

myVar=Me.Recordset.RecordCount

Luck
Jonathan

 

[Steve]

Use the Recordset.Recordcount VBA code.

For example, put the following code into your Form Open
event.

Dim iCount as integer
iCount=Recordset.Recordcount

msgBox ICount

That msgBox will enable you to verify if the count is
correct. Delete the msgBox line if all is well.

Good luck.