Maximise datasheet subform

[Snowflake68]

I have two main forms which share the screen size vertically and I have used the movesize command to set the position and size of both main forms.

The second Main form appears halfway down the screen and contains a subform that is a datasheet in the main form's header. I have some command buttons on the main form's footer and one of the command buttons I need to make the datasheet subform go full screen or double the vertical height of the screen but also keep the main form footer displayed at the bottom of the screen so that the command buttons are still available (one of which will reset the form back to the original size (hopefully)

I have been playing around with various ideas, and thought that I could get the command button to set the height property of the control (being the subform) within the main form and also resize the main form header to make room for the larger subform but I am unable to get the set property height to work.

Does anyone have any suggestions or know of anything that will definitely work please?

Once I get this working I will also need to reverse the process in order to decrease the height of both the subform and the main form header.

 

[llkhoutx]

Size the submore, it can't be maximixed.

 

[Snowflake68]

Size the submore, it can't be maximixed.

Thanks for your reply but I dont know what you mean. Can you explain further please?

 

[llkhoutx]

In the form/subform design form, make the subform the desired size..

 

[Snowflake68]

In the form/subform design form, make the subform the desired size..

Thanks but I need it to change size (Grow and Shrink) depending on the size of the Header of the main form.

 

[llkhoutx]

The subform size is independent of the Main form header. Change the subform detail section height property. This assumes everything fits on one page.

Alternatively, post a database with with form and subform.