Getting the number of records on a form - Recordcount?

[dafyddg]

Hi,

I'm trying to get at the number of records in a form. I'm currently using the code:

records = Me.RecordSource.RecordCount

but i get the error message invalid qualifier in reference to the '.RecordSource' part of the code.

The form has its record source set by another bit of code to and SQL statment so i can't simply do a count on the record source.

Any ideas?

 

[RoyVidar]

Try:

[tt]records = Me.RecordsetClone.RecordCount[/tt]

Roy-Vidar

 

[dafyddg]

That worked a treat, thanks