Hi,
I am trying to perform a calculation on a 'form' with an unbound control(either a textbox or dropdown box). I don't know if this is possible. There is a bound dropdown box with all the product listed.
What I would like to do is have the user enter or select the QUANTITY and multiply it with the PRICE of a Product and place it in another unbound field called TOTAL. As the user selects other products and/or quantities, the total would change accordingly.
(My client wants a lot of interaction, wants to use the database for price projections).
Neither Quantity or Total are the Products table.
I think I am trying to do what is called a form query?
Can this be done simply in Access or do I have to program the front end in VB. I really need to do it in the simplest way because of time constraints.
I suppose I could make a control table with the price combinations, but I thought maybe the calculations could be done at form level.
Thanks,
gzuhlk
I am trying to perform a calculation on a 'form' with an unbound control(either a textbox or dropdown box). I don't know if this is possible. There is a bound dropdown box with all the product listed.
What I would like to do is have the user enter or select the QUANTITY and multiply it with the PRICE of a Product and place it in another unbound field called TOTAL. As the user selects other products and/or quantities, the total would change accordingly.
(My client wants a lot of interaction, wants to use the database for price projections).
Neither Quantity or Total are the Products table.
I think I am trying to do what is called a form query?
Can this be done simply in Access or do I have to program the front end in VB. I really need to do it in the simplest way because of time constraints.
I suppose I could make a control table with the price combinations, but I thought maybe the calculations could be done at form level.
Thanks,
gzuhlk