Quote Form

[nikthomas]

I have been trying to create a Quote form in my Database. I have a list of products, each product then has a table that details prices based on quantity breaks (i.e 500 to 999 and 1000 to 1999 etc.).

In my Form I am unable to create a subform in datasheet view that will enable me to select a product from a combo, type in a quantity and for the price to be displayed based on the quantity?

Has anyone managed to achieve this? I would love to see the code and put it into practice.

Many thanks

Nik

 

[Uncle Gizmo]

I would suggest that you have a look at the sample database that comes with access "north wind" this has a simple order form which might have some of the functionality you are looking for .