Kumar, Hi:
I'm not one the Access gurus, but I have done this in several situations
now, involving stock, contacts and one or two other things.
One caution. The more tabs you have on a form, the longer it takes for the
form to open.
You can use either the main form as the controlling form, or include a list
sub form which can be used as the controlling form.
Whichever you use, do not forget to requery the linked forms from the main
form whenever the user changes whatever record it is on the main form that
is the main item being looked up.
Regards,
Stuart Aitchison.
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sw@tuzka.cz
Sent: Sat, 29 September 2012 17:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Tab control form
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 <mailto:access_kri%40yahoo.com> >
To: <MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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
>
>
>
>
--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar