adding data to a form

[darcy]

hey, My database im creating is a shop system with a purchase having many products. I have no idea what the code is to add the items on the add button to the subform is.

Each purchase id will have many product ids.
recording the id (which is searched for and displayed - working) and the quantity. as well as subtotals, totals etc....

any ideas..

 

[darcy]

ive picked northwinds apart, but what im after is to (like when shopping and you get a receipt) that the user enters a product id and it displays the data (this part works)
clicking the add to list button, the product id and cost is added to a subform and more can be added to.
Clicking print invoice , prints this out (prints currently the column headers only) and also closes the purchase session and returns to the main page.

Ill give northwinds another go over, but Im really stuck. thanks to uncle gizmo though.

 

[Rich]

You'll have to use Reports for your invoicing, forms are not designed to be printed

 

[ColinEssex]

Your order table should have a unique identifier (like an AutoNumber) then you should have an "Items" table where all the items for that order are stored, including the order number.

The unique order number should be on the orders form (but hidden if you like), then you can base the Invoice report on a query and in the criteria refer to the order number field on the orders form so that you can get all the items relevant to that order and print the Invoice.

Col