2 Subforms



I have a main form and 2 subforms. Subform1 links to the main form and is in
datasheet view which shows a list of items for the individuals in the main
form. Subform2 is a form view of details for the list of items in subfrom1. I
want subform1 to be linked to the main form as it is and I want subform2 to
be linked to subform1. What I am trying to acheive is when I select a record
in the main form, I see a list of items belonging to the individual (The list
is subfrom1) When I select an item in the list (subfrom1) the details for tha
items are displayed in subform2. Subform 1 and 2 are referencing the same
data. Subform1 has to linked to the mainform as a child but also has to be
linked to subform as a master. Can I link subform1 to both the main and
subform2 in this way.

Appreciate any help

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.





Mainforms are the one side, subforms are the many side. You could have the
first subform show details of the mainform and the second subform show other
details of the mainform. But I don't think you can easily get the subform to
show details of another subform.

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