Tabbed form nesting 3 deep

Hello all,

I'd like to have a tabbed form to show customers on one tab, orders for a selected customer on the next tab, and order details items for the selected order on a third tab.

Setting up the first two tabs was easy; I dragged the continuous form onto the tab and linked the Master and Child fields. However, the third tab, where I dragged the order details onto the tab, the Master list contained the Customers fields and not the order info so I could link to the order details. Is there a way to reference the order fields so I can link my detail items?

Can this be done?

You need to set up the Master/Child links to be between the two subforms and not between the main form and the subform.

If I'm understanding you right, the problem is that the links you want to set up is contained within 2nd subform on 2nd tab, and not in the parent form holding the three tabs, then the problem is quite similar to the problem of wanting two syncrhonized continuous subforms. Here's an article on this.

The gist is that you can just use a hidden textbox to hold the link from 2nd subform and have the 3rd subform reference that textbox for link.

HTH.

Thank you both - I have it now. I couldn't get it to work because I forgot that the wizard was on.