Records in Recordset ?

[101287]

How can I determine the numbers of records in a recordset? Need to know after I execute a filter command in a form if there are any records. Meaning the form will be displaying a blank form.

Would like to know record count in order to display message "no records".

Guidance will be greatly appreciated.

Luis

 

[Remou]

You can use Recordset or RecordsetClone:

Me.Recordset.RecordCount=0
Me.RecordsetClone.RecordCount=0

 

[Bruce007]

Move first then move last to get record count.