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

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.