By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Subforms puzzle

P: n/a
I have a form to display inventoried items using Access2003. On this
form I have a subform that displays a list of all my inventoried items
in the form of a DATASHEET. What I would like to do is when I
double-click on an item on the subform I would like another subform to
display that lists more details about that item. Both subforms would be
getting data from the same table but the top subform would be just:
InventoryID, Manufacturer, SerialNumber and the bottom subform would
contain more data like ModelNumber, PurchaseDate, ReplacementValue...
maybe 15 fields at most, probably displayed as formview instead of
dataview.

My first idea was to emulate the example in Northwind called form:
"Customer Orders" which contains "Customer Orders Subform1" and
"Customer Orders Subform2" however in that example Subform2 shows
order details of orders found in Subform1, thus both not coming from
the same table. Any clues as to how to accomplish this? Thanks in
advance!

Sep 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
well, being based on the same table, the recordsets of the two subforms will
have the same primary key field(s). try using the Northwind-type setup, but
in the 2nd subform control, the LinkChildFields and LinkMasterFields
properties will refer to the same fieldname - the primary key field.

hth
"Parasyke" <kr************@yahoo.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
I have a form to display inventoried items using Access2003. On this
form I have a subform that displays a list of all my inventoried items
in the form of a DATASHEET. What I would like to do is when I
double-click on an item on the subform I would like another subform to
display that lists more details about that item. Both subforms would be
getting data from the same table but the top subform would be just:
InventoryID, Manufacturer, SerialNumber and the bottom subform would
contain more data like ModelNumber, PurchaseDate, ReplacementValue...
maybe 15 fields at most, probably displayed as formview instead of
dataview.

My first idea was to emulate the example in Northwind called form:
"Customer Orders" which contains "Customer Orders Subform1" and
"Customer Orders Subform2" however in that example Subform2 shows
order details of orders found in Subform1, thus both not coming from
the same table. Any clues as to how to accomplish this? Thanks in
advance!

Sep 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.