Linking Subforms

[skriseman]

I created a form with a tab control. The main form is a customer record. On one tab I created three subforms. Subform A is a list of categories of products the customer buys. Subform B is a list of the products the customer buys in each of the categories in Subform A. And Subform C has the payment terms for the categories in Subform A. Question is: How can I highlight or put focus on a category in Subform A and have Subform B and Subform C automatically show only those products and terms related to that highlighted category

 

[930driver]

Put an invisible text control on your main form. In the OnCurrent event of form A set the invisible control value to the key value of form A.

Now link sub forms B and C on the invisible key on the main form and everything should automagically work. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[perrymans]

Why use subforms when you could use listboxes more efficiently and faster? Your first two selections could be listboxes on a single subform.

Sean.