Show Total Records in a Table on a Form

[m17347047711116]

Would like to put a box on my form that tells me how many records are in the under lying form.

 

[kidzmom3]

Creat and unbound control then on the On Current property of the form create an Event Procedure as follows

Dim dbs As Database
Dim rst As Recordset

Set dbs = CurrentDb()
Set rst = Forms![frmName]!Form.RecordsetClone

Me.UnboundControl = rst.RecordCount

 

[Jack Cowley]

This should work too...

Me.RecordsetClone.MoveLast
Me.UnboundControlName = Me.RecordsetClone.RecordCount

hth,
Jack

 

[m17347047711116]

Thank you

Thank you very much

 

[Jack Cowley]

You are welcome from both of us, though it is somewhat pretentious for me to speak for the other poster....

Jack

 

[kidzmom3]

Being pretentious is OK Jack! Your approach should actually be more streamlined. Mine was based on a subform total being stated on the main form!!!

 

[Jack Cowley]

Thanks for saying it was OK to be pretentious!

There are a lot of ways to skin a cat and we just gave the poster two of them...

Jack

PS. No cats were injured during the writing of this message...