How to select from multiple subforms from within a master form

[WCStarks]

Using Access 2016



I have a master table

Members (Contains all the personal information about each member in the organization)

I have several child tables linked to the Members table, based on primary keys, using forced integrity.

Activities (contains activities participated in by members for the organization)
Transactions (contains transactions between the member and the organization)
Committees (contains committees participated in by the members)
Organization (contains positions held by members in the organization)

I plan to have a subform for each of the child tables. I know how to create a master form, which includes an embedded subform. Doing this, however, I would have to create duplicate master forms (all with the same information), one for each embedded subform. I am sure MS has thought of how to avoid that.

What I want to do, is create only one master Members form, from which I can select, one at a time, a subform from this set of subforms, to work with. And, once the subform has been selected, I want it to update as I browse from one Members record to the next in the master form.

I cannot figure out how to do this, even after extensive searching on the Internet.

[June7]

Not sure what the issue is. A 'master' form can have many subforms placed on it. Can organize them on pages of Tab control.

[WCStarks]

Here is my db. I originally started out to just keep track of transactions. Now we are interested in having me track the other aspects of the organization. Currently, I have two master forms: Members Trans and Members Acts. I really just want one Members form with multiple subforms for each of the other child tables.

I didn't mention the Events table previously. As you can see from the Relationships screen, it is linked as a parent to only one child table, the Activities. The Activities table provides a cross-link between the Members and the Events table. From the event perspective, the activities subform would add names to each activity row, retrieved from the Members table. The Activity subform from the Members perspective, would not add the member names to each activity row. Since there will only be one subform for the eventual Events parent form, it is not an issue, as I already know how create the form and embedded subform for the Events table.

[June7]

Doesn't alter my suggestion.

One Master form, one Tab control, multiple subforms.

[WCStarks]

Doesn't alter my suggestion.

One Master form, one Tab control, multiple subforms.

I wasn't challenging your suggestion. I simply do not know how to do what you suggest.

[WCStarks]

OK. I found out how to create a tab control. I have named 4 tabs. I only have subforms for the 1st two tabs, at this time. I dragged and dropped the Transactions and Activities subforms into their respective pages. This looks just like what I want, but there is just one problem. When I click on a tab, it initially shows the subform in the selected page, but then it immediately opens the subform in the full db window, in single form mode, on a level with the Members tab, obscuring the Member form and related subforms. What am I missing to get it to work properly? Please see attachment.

Scateam - Copy (2).zip

[June7]

You don't know what a Tab control is?

Research Tab control. Can put subform container on each page of Tab control. Using a Tab control does not alter how subform links to master form.

http://www.jegsworks.com/Lessons/dat...tabcontrol.htm
https://support.office.com/en-us/art...84183C9815#bm4
https://www.youtube.com/watch?v=NboJDp02zcw

or this approach using VBA
http://accessjitsu.com/2015/10/04/ms...iple-subforms/

[June7]

Remove the embedded macro that opens form.

If you want to open form to single record then that's exactly the behavior you will get with db set up for Tabbed Documents. I prefer Overlapping Windows.

[WCStarks]

Thank you. I had initially set an event on click for both tabs, but later realized that was a mistake. I thought I had gotten rid of them, but I guess not. It is working now. This is great. Thank you again.