S
socasteel21 via AccessMonster.com
Help!
I have a purchase order form for construction equipment. A combo box is used
to filter the records of a subform containing all the options available for
each model. I have included a checkbox in the subform called "Select Option".
If you check the box the price of the option is added to a subtotal. The
subtotal grows with each new selection. This total is then displayed on the
main form.
I need to be able to store the PurchaseOrderID along with the part number for
each option. The part number field is also displayed on the subform.
I do not want my selection to change my original options table. The subform
is based on a query of that table. The main form is based on a seperate
table called tblPO.
Any help would be greatly appreciated.
Shannan
I have a purchase order form for construction equipment. A combo box is used
to filter the records of a subform containing all the options available for
each model. I have included a checkbox in the subform called "Select Option".
If you check the box the price of the option is added to a subtotal. The
subtotal grows with each new selection. This total is then displayed on the
main form.
I need to be able to store the PurchaseOrderID along with the part number for
each option. The part number field is also displayed on the subform.
I do not want my selection to change my original options table. The subform
is based on a query of that table. The main form is based on a seperate
table called tblPO.
Any help would be greatly appreciated.
Shannan