Access 2007 Multiple tabs in subform?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

melonhead

Thread Starter
Joined
May 6, 2002
Messages
882
I am making a contact management database. I am working on a form with a subform (or if needed subreport).

The Tables are Main Family Table (Form) and Family Members (subform)
Basically the Main Family Table contains address, last name and phone.

The Family Members contains info about the individual family members - name, e-mail, insurance info, etc.

I want to have only one table with the home address so that we can send one statement to a family instead of wasting money and sending numerous statements.

I have tabs on the subform. I would like each individual family member to have their own tab. So if the Smith family had 3 family members, there would be three tabs to choose from - each labeled with the family members name. If the Jones family only had one person, there would only be one tab.

Can this be done?

Thanks in advance
 

OBP

Joined
Mar 8, 2005
Messages
19,895
hello melonhead, I am sorry but I don't think your idea is going to prove very practical, I am not saying that it can't be done, but it will be a lot of work.
First of all, unless you Program the tabs and their names using Visual Basic you are going to need a Mainform with SubForms for each Family.
The normal way to do this would be to have a Combo Box to select a Family and then a Subform with One Record per Family Member.
The decision is yours as they say.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top