Thanks Jma. I was able to follow your method and get the desired results.
Kind Regards,
Kumar
--- In MS_Access_Professionals@yahoogroups.com, <sw@...> wrote:
>
> 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@...>
> 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