I want to know how many sub-form layers I can go in Access 2007. I have a form on which I have dragged two sub-forms, but now, I have further logic conditions which call for a sub-form of a sub-form. So I have this:



Table1---->Form1---->Sub-Form1

Table2---->Form1---->Sub-Form2

I now need to do this:

Table1---->Form1---->Sub-Form1
..................................|--------->Sub-Form1a

Table2---->Form1---->Sub-Form2
..................................|--------->Sub-Form2a

I want to know how to do this and I want to also know how I would do further sub-forms such as Sub-Form1a----->Sub-Form1aa, etc.

I would also like to know if there is a way to present a STACKED Sub-Form rather than the horizonal sub-form that seems to be the stock appearance.
I have a lot of fields and its a pain having to scroll far to the right just to enter data. I am calling it a "STACKED" appearance, meaning that the fields will be presented in a vertical rather than horizontal manner.

Thank you for any help you can provide. Further, if you have an example or know of one that would show me how to do these things, please let me know.