Subforms Code

[Angel_G]

Can anyone help me with the following?
I have a Main form (OrderHeaderfrm) with 2 subforms in it. The main form has
orders displayed and coded it so that when I click on a order the Ordersfrm
form(which is one of the Subforms) displays the Order line details for that
specific order revealing Partnumbers, Orderqty, etc. The Orderfrm is coded
so that when I click on a part number the part number gets copied to a
field(PartNo) in the Main form.
What I want is; for the third form (ItemDemndsfrm) to be Queried based on
the PartNo field. All is there, all I need to do is trigger that event from
the subform.
Is this possible? I have tried it but I get errors saying the form is not
loaded and so on.
Please give me some insights on what I am doing wrong or if there is a
better approach on this.
Many thanks!

 

[Steve Schapel]

Angel,

Normally there is no need for any code to manage this type of situation.
Correctly setting the Link Master Fields and Link Child Fields
properties of the subforms is normally sufficient.