I have created a form that contains a Tab Control. The 1st Tab contains Company Info, I would like the second tab to contains Contact Info from the Company. I have completed the first tab, my problem is the second tab. The contact data is house in another table. How do I bring the data from another table to tab 2 and have them joined?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Form -Tab Control
- Thread starter Adams
- Start date
- Thread starter
- #3
- Thread starter
- #5
- Thread starter
- #6
Hi!
Okay, in general this is how you should set up this type of form with tabs. On the form it self (detail section) you will place the company identification information: companyid, companyname are the two most common. The tab control will be in the detail section as well. On the first tab place company demographic information: Address, city , state, zipcode, general phone/FAX numbers, website etc. The contacts should be stored in a separate table which will have the companyid and the contact information (you should probably set up a contactid as an autonumber to keep the number of fields in the primary key down). Then on the Contacts tab of the form place a subform and, going through the wizard choose the contacts table as the source and the companyid to connect it with the main form and datasheet view. When you go from the main form to the sub form, Access should save the record in the main form and you should be able to edit add and delete contacts.
If you can't, let us know but, at that time we will need extensive information about your application to help.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
Okay, in general this is how you should set up this type of form with tabs. On the form it self (detail section) you will place the company identification information: companyid, companyname are the two most common. The tab control will be in the detail section as well. On the first tab place company demographic information: Address, city , state, zipcode, general phone/FAX numbers, website etc. The contacts should be stored in a separate table which will have the companyid and the contact information (you should probably set up a contactid as an autonumber to keep the number of fields in the primary key down). Then on the Contacts tab of the form place a subform and, going through the wizard choose the contacts table as the source and the companyid to connect it with the main form and datasheet view. When you go from the main form to the sub form, Access should save the record in the main form and you should be able to edit add and delete contacts.
If you can't, let us know but, at that time we will need extensive information about your application to help.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
- Status
Similar threads
- Locked
- Question
