count records

[peterbowles]

I have used this code before to count records on a form and it worked but now is does not any ideas?

Dim myrecords As Recordset
Set myrecords = Form.RecordsetClone
Me.txttot = myrecords.RecordCount

is there another way to count the no. of records on a form

thanks

 

[ghudson]

I use RecordsetClone in my forms to give the X of Y count. Does this work for you?

MsgBox "Total records = " & Me.RecordsetClone.RecordCount

Are you missing any references? If not, deselect one that is okay and then reselect it to force a refresh.

HTH