Sub-forms expand based on records

[miacino]

I have a sub-form which I'd like to "expand" based on the number of records. I know grow/shrink is not used for something like this.

I'm not a proficient coder, but I tried this:
Me.frm_subAssetEdit.Height = Me.Section(0).Height
I put this code in the On Resize property in the sub-form, but when I open the main form, the sub-form is blank.

Any thoughts?

 

[isladogs]

The fact that the subform is blank is nothing to do with its height.
Fix the data issue first
Check the subform record source and the field or fields used to link main form and subform

Then look at related threads to see if the solution has been described before
E.g. https://www.access-programmers.co.uk/forums/showthread.php?t=227645