Grow subform

[Samantha]

I have 3 subforms inside the Main form.
Each subform is linked to a different table, to show different information,
based on the selections made on the Main form. The subforms are in continuous
format.
Is it possible to set the subforms to "grow" or "shrink" as the number of
line items varies depending on the selections made in the Main form? If this
is not possible, then there would be a lot of blank spaces when in between
the subforms.

Thank you.

 

[Damian S]

Hi Samantha,

A couple of options for you:

1. Make your subforms a smaller height and include a vertical scroll bar

or

2. Use a Tab Control to display one subform per tab (with main data on main
form)

Hope that helps.

Damian.

 

[Peter Hibbs]

Samantha

A Flex Grid control would do what you want (if you are prepared to
write a fair bit of VBA code). Have a look at my Flex Grid demo
program at -
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S
for some examples.

Peter Hibbs.