472,145 Members | 1,474 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

How to toggle record sources of 2 subforms that must be visible on a main form

Hi there,

I have a form to organize bottles in mind, but am unsure if it will
work. Here's some background info:

Mainform = frmProduct, which contains fields for pricing, status, etc.
of complete bottles, as well as an image control for a thumbnail of a
complete product (bottle + cap).

The mainform has 2 subforms that must be visible and side-by-side:

sfrmBottle, which contains data on bottle dimensions, name, etc., as
well as an image control for a thumbnail of a bottle (without the

sfrmCap, which contains data on bottle cap specs, name, color, etc.,
as well as an image control for a thumbnail of a cap (without a

Since many caps can fit 1 bottle, and many bottles can fit 1 cap,
there is a many-to-many relationship, so I have 2 main tables
(tblBottles and tblCaps) and a join table (jtblProducts).

The mainform's record source would be the join table, jtblProducts,
and the subform's record sources would be the other 2 tables. So,
before a product can be finalized, the particular bottle + cap
combination must be entered into the subforms, and then 'applied' to
the final product.

I've seen something similar to this before, but only 1 subform was
involved, and the data in the subform's underlying table had to be
entered in prior to being applied to the main form's record (The main
form's record was a default record until otherwise changed).

The scenario: the catch is that I'd like to be able to toggle the
filtering or linking of the subforms with the mainform. This would
allow a user to browse through the various bottles and caps in the
subforms separately until they find a combination they like, then
apply them both to the final product. They then could turn the parent
/ child linking back on to continue looking through all the existing
product combinations on the main form, while having the the
corresponding data in the bottles and caps subforms change

Would anyone have any ideas how this could be accomplished?


Nov 12 '05 #1
0 1662

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by CSDunn | last post: by
7 posts views Thread by ChrisR | last post: by
6 posts views Thread by Steve | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.