Displaying number of records in textbox

[Handford]

I would like to display the number of records (like seen using the navigation buttons) in a text box on my form. Is this possible? Will it update when filters are added to the data?

Thanks,

Chris

 

[PHV]

Something like this ?
=Me.Recordset.RecordCount

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Handford]

Thanks, but I don't seem to be able to get hat to work.

I put =[Me].[Recordset].[RecordCount] in the control source property of the text box but unfortunatly it did not recognise it.

Am I using it right?

Chris

 

[PHV]

And this (don't use brackets)?
=Me.RecordsetClone.RecordCount

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Handford]

Sorry about this. I have tried both and neither seem to work.

However when I put the =Me.RecordsetClone.RecordCount into the control source property it automatically adds brackets and becomes =[Me].[RecordsetClone].[RecordCount] on lost focus.

Chris