How do i am values from list boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making an invoice for a company i work for and ive made it so far so
that you select from a drop box the type of product and it requeries another
drop box to show the different products and once you select one it displays
the price in a list box. i want to have a sub total, tax, and total
automatically tallied and to do that i have to add the values from list boxes
on the page, i have ten made because the invoice allows up to ten products to
be sold at a time. so how do i add the list box values (there is only one
item in each of the list boxes: its price).
 
Why don't you look at the sample database "Northwinds" that comes with
Access and create a similar design. Typically, you would not list the tax
for each product, you'd list the tax for the invoice total. (I've never
gotten an invoice with tax on a line item basis)
 
No not a tax for each item, i need one subtotal amount, one tax, and one
total amount on the form. my problem it that my prices are displayed in list
boxes because when i select the product from a drop box and try to have the
price displayed in a text box it doesnt come up in a currency format so i
need to know how i can change that or if i can add up values from the list
box it self with my price in it.
 
Back
Top