Main Form Plus Tabs

[CementCarver]

I'm designing a db that will have one main member contact form, but I also require to house additional information ie. memberships that I'd like to have displayed in tabs that the user can select to see this additional info.

I'm hoping to first allow the user to search for a particular record and then display this in the main form, but I also want the tabbed forms to populate regarding that searched item.

Does anyone have a sample database that I see use so that I can understand the code requirements behind this main form and it's other tabbed forms?

CementCarver

[June7]

What is the data structure? Is this additional info from child tables related to the member record? What do you mean by 'main form plus tabs'? Is this a Navigation Form? Or is this a tab control with subforms on the tabs? Proper form/subform arrangement of related data does not require code.

[CementCarver]

I guess it's my terminology that's confusing. I have a main contacts table which I'm hoping to relate, via a lookup table, to other associated tables, and to be able to display the main contact screen, but if the user wanted to see additional data relating to that contact, then I was considering to have additional tabs to guide them. So, to clarify my answer, it would indeed be a main form with a subform. But I was just not sure how to design such a environment.

In my case, a contact may be involved with one or many types of activities. For example, a contact may sell automotive parts, or they may sell garden supplies etc. So after searching for a main contact, I was hoping to associate that type of items they may sell.

CementCarver

[June7]

Use form/subform arrangement to display related records. However, if you want to restrict the products that can be selected for a contact when creating new child record, need code to limit the RowSource of a combobox that lists products.