Assigning Total price to Textbox

[mercury]

Hi

Im having a problem.In my database i would like the user to select a choice from each of my five combo boxes, Each selection is attached a cost.

In a textbox(txt1) this seletion would be concatenated and a total price is supposed to be in another textbox(txtTotalCost). Im having a problem with the total price. What i did was to assign the price to the the item selected in the combo box using code. But i realised that if the user wanted to change the price they wouldn't be able to do that.

Example:

if cbo1 = "Paper" then 
                   txtCost = 3 
              end if

What i would like to do is to refence the table or query for the prices, so that i can total them and if the user wanted to make changes to the prices they could do so using a form i would provide on the form to make changes. But i have no idea where to begin. Can someone offer me some help please.

Thanks
Mercury

 

[yessir]

create a table for products that has

id product price category(ie one of your 5 cbo's) quantity availability

create your form based on this with your cbo's having 3 columns

id product price

make only product visible, and make the price the bound column

whenever an item is selected/changed in your cbo have you textbox add/subtract the price then add the new price


~HTH