Calculating prices on a form

[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!

 

[Damon Heron]

No need to re-invent the wheel. Look at the various Access templates and
examine one of the dbs that have invoicing. I believe there is one called
"Orders" or "Order Inventory" or something like that. Then just import the
forms and/or code into your db.

Damon

 

[Klatuu]

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.