Determining number of records displayed on a form...

[Brad Pears]

I have a form/subform in a parent-child relationship. Is there a method I
can use to give me the total number of records currently displayed in the
sub-form (the child form)? Currently I am doing a "select" and then getting
the recordcount from the recordset object. Another method I have used is the
dcount function and send it the recordsource property for the form... Is
there an easier way, something like "me.count" or something along those
lines?? ( I actually think the .count method of the .Form object returns
the number of open forms??

Thanks,

Brad

 

[Roger Carlson]

Do you want it displayed on the main form or the subform. If on the
subform, try:

Me.RecordsetClone.Count

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Brad Pears]

Thanks for that Roger. I actually had to use ".recordcount" as opposed to
just ".count "- but using the "recordsetclone" method worked...