"Cascading" subforms

[Joe Williams]

I have an Unbound form with two subforms on it. One subform is OrderHeader
information, the other subforms is OrderDetail information. The main form
serves no purpose except to hold the two subforms.

I would like to select an OrderHeader record in subformA and have the
OrderDetail records displayed in subform B.

When I add both subforms to the form and try to build the Master.Child links
it gives me an error "Cannot build link between unbound forms"

How can I accomplish what I am trying to do? Thanks

Joe

 

[Rick Brandt]

I have an Unbound form with two subforms on it. One subform is OrderHeader
information, the other subforms is OrderDetail information. The main form
serves no purpose except to hold the two subforms.

I would like to select an OrderHeader record in subformA and have the
OrderDetail records displayed in subform B.

When I add both subforms to the form and try to build the Master.Child links
it gives me an error "Cannot build link between unbound forms"

How can I accomplish what I am trying to do? Thanks

Don't use the builder [...]. Just enter the properties yourself.

 

[Steve Schapel]

Joe,

Put an unbound textbox on the main form, with its Control Source set to
the equivalent of...
=[OrderHeader]![IDfield]
Then use this textbox for the Link Master Fields propery of the
OrderDetail subform.

If I understand you correctly, another approach to this situation would
be to use OrderHeader as your main form, with OrderDetail as a subform
in the Form Footer section of the OrderHeader form.