"Cascading" subforms

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

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
 
Joe Williams said:
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
Click to expand...

Don't use the builder [...]. Just enter the properties yourself.
 
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.
 
Back
Top