S
socasteel21 via AccessMonster.com
Hello,
I have a combo box called "Model Number" that filters records on a subform to
display a list of options along with pricing and other information for the
selected model.
After I select the model (i.e. RT60), several records are displayed in a
subform. Each of which has a check box in a field called "Select Option". I
would like to be able to check any combination of records on the subform and
have access calculate a price based on the total for each option.
The subform is based off a query of a table which includes all of the options.
After totaling these options, I would like to have a print function that I
could use to print off a purchase order to the customer with all options and
prices displayed.
Any help is greatly appreciated.
Shannan
I have a combo box called "Model Number" that filters records on a subform to
display a list of options along with pricing and other information for the
selected model.
After I select the model (i.e. RT60), several records are displayed in a
subform. Each of which has a check box in a field called "Select Option". I
would like to be able to check any combination of records on the subform and
have access calculate a price based on the total for each option.
The subform is based off a query of a table which includes all of the options.
After totaling these options, I would like to have a print function that I
could use to print off a purchase order to the customer with all options and
prices displayed.
Any help is greatly appreciated.
Shannan