Form problem!

[BA777]

Hi everyone,

I'm working on a database at the moment for my dad, and what I'm in the process of doing is making a form in the Forms section of Access 2003 that I can then introduce as a subform in a larger report etc used to make a quotation for a number of products as the end result.

What I'm aiming for in this certain subform is the following, excuse the basic layout but its hard to draw...

-------------OPEN FORM HEADER-------------

Product ID Product Title Product Description Quantity Sale Price

-------------DETAIL------------

Product ID Product Title Product Description Quantity Sale Price



My point is that in the detail, I want this form to be added to a larger form and then use it to select products for the quote. The thing is a quote may contain anywhere from 2 products to 20, such is the variety and I need some assistance in how to set this up to work properly so that when I select the Product ID (As a combo box that also shows its title), it fills in the title, description and then based on the quantity it calculates the price at the end.

The Product ID comes from "Tbl Products", as do the Product Title and Product Description and the Sale Price, and the quantity is just say 1,2,3 which then multiplies by its normal price for one to make a total.

Any help much appreciated, I probably havent explained myself too well so I can try again if thats neccessary.

Thanks!

Henry

 

[ansentry]

Welcome to the forum.

Have a look at my sample that I posted [URL="http://www.access-programmers.co.uk/forums/showthread.php?t=109162"
]HERE[/URL]

Its called InvoiceSavePrices180606.zip it is for invoicing but you could change it to quotes. Any questions post back.

 

[BA777]

Hi,

Thanks for that link it's helped a lot!

I've setup a query that shows all 63 products that can be chosen to go into the quote. Now I want to make a form where I can select just on a one-by-one basis as in the sample you provided that then fills in the rest of the details about it and automatically adds a new row below for the next product - how can i do that?

Thanks,

Henry

 

[ansentry]

how can i do that?

You need to replace my parts table with your products table, I am only guessing as I have not seen your database. If you do this make sure that you make the changes so that pricing changes can be made to the "products" table.