nadir66
IS-IT--Management
- May 30, 2002
- 34
- 0
- 0
Hi
I ghave a form (tbl_inv) that has a subform (tbl_code_querry) that are joined through a field called code. The subform is a continuos form because there can be many items under same code but different manufacturer.
My problem is how to update the subform using the order items.
(ACC97, OS XP)
To clarify; in tbl_inv the field code has description, quantity and branch (manufacturer)the subform the sasme items, but in multiple instances.
Once the user hilites the branch he wants to order items from, clicks on order, fills out the order, in a hidden box i can calculate what i have left. How can i save that q instead of the first one (old vs new q)
Thanks
I ghave a form (tbl_inv) that has a subform (tbl_code_querry) that are joined through a field called code. The subform is a continuos form because there can be many items under same code but different manufacturer.
My problem is how to update the subform using the order items.
(ACC97, OS XP)
To clarify; in tbl_inv the field code has description, quantity and branch (manufacturer)the subform the sasme items, but in multiple instances.
Once the user hilites the branch he wants to order items from, clicks on order, fills out the order, in a hidden box i can calculate what i have left. How can i save that q instead of the first one (old vs new q)
Thanks
