If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. http://www.microsoft.com/office/comm...c.access.forms |
#2
|
|||
|
|||
2 Subforms
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. "DB" wrote: 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. http://www.microsoft.com/office/comm...c.access.forms |
Thread Tools | |
Display Modes | |
|
|