Subform within a subform (2 Viewers)

[SteveI]

Is it possible to attach a subform2 to subform1. Subform1 is already attached to a mainform.

e.g. Recipe Info = Main form (Apple Pie)

Recipe Ingredients = Subform1 (Flour, Milk, eggs)

Ingredient Breakdown (Flour = baking soda + wheat + salt)

The relationships between primary keys etc becomes confusing to me.

your help will be greatly appreciated.

 

[vbaInet]

The following link should give you some insight:

http://www.access-diva.com/f2.html

 

[manda]

try this one www fmsinc com microsoftaccess forms synchronize linkedsubforms.asp

replace spaces above with forward slash as i cant post links

the only thing is you need to 'click' on subform 2 to have it update the selection from subform 1

 

[gemma-the-husky]

yes, but access will do it automatically if you have single forms (ie forms showing one record at a time), but won't if you have continuous forms. If the latter, you need to use a different method to achieve the result you want.