Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Forms _ Record Count In A Subform

Posted by: whdyck Jan 11 2017, 11:01 AM

Probably a bonehead question:

I have a subform (fsubUntAsnUnitBookingsCardex) that displays no records when the form (frmUntAsnUnitBookingsCardex) is opened.

However, if I then run the following command from the Immediates window (with no records displayed in the subform):

CODE
?Forms!frmUntAsnUnitBookingsCardex.fsubUntAsnUnitBookingsCardex.Form.count

I get back 33. How is that possible?

How can I get the true record count in this subform?

Thanks.

Wayne

Posted by: DanielPineault Jan 11 2017, 11:05 AM

See: http://www.devhut.net/2016/08/09/display-the-record-count-of-a-subform-on-a-main-form/

Posted by: whdyck Jan 12 2017, 08:06 AM

Thanks, Daniel.

Is it possible to post the attachment in an Access 2003 format?

Thanks.

Wayne

Posted by: DanielPineault Jan 12 2017, 08:50 AM

Try the link again, there is now an mdb sample available to you.