Dynamic SubForms positioning

[accessNator]

I have 3 subforms in my main form. The data from the subforms pull from 3 different tables.

To get the data to populate the subforms, they choose a given month i.e. Jan, Feb, March...etc. for the criteria

Depending on the criteria, I can have upto 3 subforms to appear or no subforms at all if the criteria does not meet.

If any do subforms appear, I would like them to appear but spaced out or positioned evenly from each other vertically.

i.e.
.5" apart

But the size (height) of each subform is dynamic too depending on the criteria.

I cant seem to get a grasp on how to dynamically position each given subform to appear and space them evenly.

Anyone have an example they can refer me to?

 

[Magster]

Have you given any consideration to using tabs on your form. This would not allow you to view all 3 forms at once, but it does save space.

 

[accessNator]

Have you given any consideration to using tabs on your form. This would not allow you to view all 3 forms at once, but it does save space.

Magster, thanks for your reply.
I have considered that, but boss doesnt like that solution. I figured it out so if anyone wants to see the solution, just PM me.

 

[smig]

you can use -

if me.1stSubReport.visible = true then
me.2ndSubReport.left = me.1stSubReport.left + me.1stSubReport.width + 0.5
else
me.2ndSubReport.left = 0.5
end if