Tab Control - Sub forms - Link Data

[Missionary2008]

I have a database that I'm using multiple forms to gather information into separate tables.

Ex. tblA, tblB, tblC, and tblD

I have frmA as the master form which collects on the information for all the tables. It does so by the Tab control I inserted along with frmB, frmC, and frmD.

I'm trying to link the fields ID, Company Name between all the tables and forms. So when I enter the information into frmA it populates the information into frmB, frmC, and frmD.

Thanks in advance for your help.

[NeoPa]

It's hard to know what you're actually asking here.

One thing I can say though, is that you will need to give some clues as to how these tables link together etc. We can deal with very general questions, but only at a very general level.

[Missionary2008]

I have 4 tables: tblSponsorInformation, tblNC08Sponsor, tblNC10Sponsor, and tblFC11Sponsor.

tblSponsorInformation contains all the contact information information about a particular sponsor. Specifically - the fields ID (the primary key) and Company Name.

The other three tables consist of information that is specific to a particular event. For example, tbleNC10Sponsor has all the information relating to a National Conference - specifically a field with a drop down list of features available and features purchased to sponsor the conference.

I've created a master form for our sponsorship team to us and to avoid having information overload. On that form - I have all the information for the tblSponsorInformation on the left side. Ont he right side - I added a Tab Control box with three tabs. Each tab represent the three tables (tblNC08, tblNC10, tblFC11). I have tried adding the subform/subreport to the repective tabs. Two issues come up:

1) My drop down list for sponsorship features doesn't come through like it does when I just create a report. It's wanting the "value" and not allowing a drop down list.

2) When I add information to the form on the left side (linked to tblSponsorInformation) it does not add records to tblNC08Sponsor, tblNC10Sponsor, and tblFC11Sponsor.

I hopes that helps. In a nut shell I want to use one form with sub-forms to fill out the information need into my four tables.

[NeoPa]

First let me apologise for the long delay. I admit I have struggled to understand what you're explaining and been unable to form a picture in my head of what you're about. I thought it only fair to answer what I can though. Maybe any confusion can be clarified from there.

Missionary2008:
1) My drop down list for sponsorship features doesn't come through like it does when I just create a report. It's wanting the "value" and not allowing a drop down list.

I don't know what you mean by come through. I don't know what happens when you create a report. I guess that somehow the ComboBox control you're referring to is not working as expected, but that's too little to be able to help you.

Missionary2008:2) When I add information to the form on the left side (linked to tblSponsorInformation) it does not add records to tblNC08Sponsor, tblNC10Sponsor, and tblFC11Sponsor.

This will always be true. Subforms don't create records for you. They may set the values for linked fields if properly set up, but that's about it.

However, the fact that you even mention it leads me to wonder if you have relationships, or joins, between the tables which are one-to-one possibly? I see no reason why that would be a good idea, but neither can I see your project. If that is the case than that would be pertinent information. We'd need to know this to be able to help you, and not guide you in a wrong direction.

It is possible, using code, to force a subform to create records for you triggered by creating a record in your main form. I cannot imagine a situation where it would be a recommended direction though. I'd need a better understanding of your thinking before guiding you that way.

[Missionary2008]

NeoPa,

Sorry for the delay in responding, I spend some time taking your comments and trying to figure it out myself - and I did! thanks. sometimes I just need a little push.

[NeoPa]

That's about the best result then. If I feed you answers then you won't learn too much. Finding them for yourself puts you in a much better position though. Well done :)