Display All Records in Continuous Subform without Refreshing

[avalentini]

Hello,

I have a form with several continuous subforms that I wish to automatically resize based on the number of records they contain. I've been able to do this by having Me![subForm].Form.Section(acDetail).Height a function of Me![subForm].Form.Recordset.RecordCount. The only issue is when I open up the main form or switch from record to record only two records are displayed in the subform. Furthermore, if I run Debug.Print (Me![subForm].Form.Recordset.RecordCount the result is "1". However, if I click the "refresh all" button, all records are shown and the subform resizes itself accordingly. I've tried running Me![subForm].Form.Recordset.MoveLast before the RecordCount operation, but it simply displays the last record in the record set, and printing RecordCount still returns "1".

Thanks for any help.

[ranman256]

.RecordCount wont work unless you goto the end of the recordset, THEN it gets the count.
so instead, use DCOUNT("*","qsSubformQuery")

[avalentini]

How do I use that function such that it returns the number of records in the subform and not the total number of records in the table the subform is referencing?

[June7]

RecordCount code works for me.

Why even do this? This is why forms have scroll bars. Could there ever be too many records for all to display without scrolling?