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

[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!