Calculating prices on a form

  • Thread starter Thread starter rye1982
  • Start date Start date
R

rye1982

I would like to make an invoice form in which, when loaded, it calculates
prices.

For example, the user has entered the number of products into a table and
the form multiplies the number by the price, housed in another table.
I'm also thinking I'll need an IF statement somewhere as well, as I need to
check whether the customer is based in the US or Canada, since prices vary
depending on the country. Any help on this point would be useful.

Thanks a lot!
 
The Northwind Database that comes with Access.
They are the Orders and Orders Subform Forms

To be able to use multiple price lists, you would need to have a table
structure that supports them and then modify the code in the Orders Subform
ProductID After Update event to select the correct price.
 
Back
Top