Hi all,
I really need some helps.
I created a main form("category"), which contains a subform1, "Part".
Inside this subform also has contains a subform2, "Inventory".
The second level of subform, "Inventory" contains the field of quantity
in and out, and therefore I create a text box to do the calculation for
UnitOnHand. One textbox is also prepared in subform1, "Part", to get the
value shown in the UnitOnHand text box.
When I prepare the Form using "Part" (which means it becomes main form
and "Inventory" becomes subform), the calculated value can be shown
correctly on the "Part" form. However, when I create the Form using
"Category" (which means "Category" becomes main form, "Part" becomes
subform1, and "Inventory" becomes subform of the "Part" subform), the
calculated value cannot be shown, but "#Error" instead. If I click on
the + sign beside each item, the value will be shown.
How can I make it such that all the value can be shown automatically? I
try using Requery but no effect...
Help me pls....
*** Sent via Developersdex http://www.developersdex.com ***