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!

 

[diamondDog]

do you mean like this.

Good day to you, once again, solver of problems.
I have another form that I want to use this tech on, but the records are occasionally so many that the header takes up the whole form from the subfrom record count and the user has hardly any room to fill out the main form details section.

Is there a reasonable way to have the subform the top of the details section on the main form so that a user can scroll down beyond the continuous subform records to fill everything out? In other words, is there a clean way to have all the main-form fields dynamically move up and down to accommodate the continuous subform's resizing based on record count so that the subform doesn't create a large gap of space between it and the main-form details section or so that a large subform size doesn't overlap the main-form details content?

I really love how clean the resizing of the header works in your database, but I don't believe there is any way to change the header to being something that isn't always frozen to the top of a form; otherwise, that might be the best solution.

 

[Mark_]

Yes, it's missing a 'Then' at then end of the line.

That's what I get for typing in the response directly instead of letting Access tell me I forgot something!