1) main form -> main table as source.
2) make solo form for each sub-table and name it as like as subformXY.
3) in main form put on each tab one sub-form as subform-control.
4) in properties of each subform control set LinChildFields and LinkMasterFields property.
More you find sure by google
-jma-
----- Original Message -----
From: "access_kri" <access_kri@yahoo.com>
To: <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, September 29, 2012 4:06 PM
Subject: [MS_AccessPros] Tab control form
> Dear Group,
> Can tabbed control editable form can have data from only one table or multiple tables can be used? I am trying to make an
> tabled form for Equipment specification. As equipment specification can have several sections such as Name plate details, Design
> parameters, Operating parameters, constructional details, material of construction etc. I created separate tables for each of
> these categories and linked them together with EquipmentID field. Thus all tables are having one-to-one relationship with
> equipmentID in the NamePlate table. I am then basing my form on query that pulls information from all the tables. However, the
> query is not editable and It only displays the records but I cannot add new records. How I can create a tabbed form which contains
> information from all these tables?
>
> Thanks and Regards,
> Kumar
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> http://help.yahoo.com/help/us/groups/messages/messages-23.html
>
>
>
>
Tidak ada komentar:
Posting Komentar