Can you do a sub-Form in a sub-Form ?? (Nest sub-Forms)

M

MyEmailList

How deep can you do sub-Forms ?

Can we do this?

frmAccount
...sub_frmOrder
.....sub_frmOrderItem

This may be a poor example. Ignore the urge to talk about the problems
with many-to-many relationships. That is not a problem in this case as
each order item is unique to each order.

The question is can we nest sub-forms 3 deep... or deeper?

thanks for any help.

Mel
 
R

Rick Brandt

How deep can you do sub-Forms ?

Can we do this?

frmAccount
..sub_frmOrder
....sub_frmOrderItem

This may be a poor example. Ignore the urge to talk about the problems
with many-to-many relationships. That is not a problem in this case as
each order item is unique to each order.

The question is can we nest sub-forms 3 deep... or deeper?

thanks for any help.

Mel

Access 97 three deep.
Newer versions 7 deep (I think)

What you cannot do is use a subform in a continuous form except in the
header or footer so as soon as you hit a subform level that is using a
continuous view(which is the most common) then it is difficult to go any
deeper even if it technically is allowed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top