Problem Subform

Ronaldo1985 · 2010-05-11

Very good to everyone!
I have a problem I would like to know if there is any solution, I mean

I have a form that pulls from a table 'X' in this form Subform I have two more, the first strip of the table "Sales Header" which is related to table 'X', So far so fantastic! the problem is with the second subform I have referred to the table "Sales-line, this want to show all lines that refer sales to current record of the first Subform (Sales Header), I get this from the OnTimer event , but this is one heck, it works but .... I can not change the lines of the second Subform because before you insert anything directly OnValidate me I try to fill in the field and gives me error ....

I hope I explained clearly, many thanks in advance.

KYDutchie · 2010-05-11

Hi,

If I understand you correctly, you have a form with at least 2 subforms. And you want to update the data visible in the second subform based on the selected, current record in the first subform.

This is possible, I have done it before. I use the XML trick. When you select a record in the first subform it will trigger the event on the main form. The main form can then update the second subform.

take a look at this post:
http://www.mibuso.com/forum/viewtopic.php?t=22564&highlight=
or this one
http://www.mibuso.com/forum/viewtopic.php?f=23&t=41219&hilit=XML

I hope this helps,

Regards,

Willy

Ronaldo1985 · 2010-05-11

Thanks you!!!

Problem Subform

Comments

Categories