Solved I use VBA to adjust the height of a continuous subform based on # of records, but my subform only adjusts to show up to 3 at a time w/ scrollbar

[diamondDog]

here is the fix. see the code behind the Main form.
also i added Index (Unique) on MainTbl on Account field.
same on SubTbl, but the index this time is not Unique.
also added Relationship between these tables.

Oh wow, it works beautifully! Top-notch job!! Thank you!!

Does the table relationship improve performance speed?

You have already done so much to help me, but since you are very familiar with your code, might I trouble you for a functional and aesthetic addition?

I wanted the subform within my main form's header because I was hoping that the header might increase its height based on the current subform size (which it does, actually) and that it would also shrink again to wrap nicely around each record's subform row count (while also maybe always maintaining a handful of twips between the bottom of the viewable subform and the header).

Would this be possible so that there won't be a header gap preceding the Details portion of the main form for each main-form record?

Thanks again! May your code help countless folks who stumble on it!

 

[arnelgp]

do you mean like this.

 

[diamondDog]

do you mean like this.

YES!! Wow! This is so great! Thank you so much! There is much I can learn from your code and from your kindness!