Addition of cost in a subform via lookup

[mrapoc]

Hey

I am creating an inventry system and so far so good for a beginner.

I have created an ordering system, extremely basic which is getting there.

I need to be able to add the total cost up to the footer of the subform which I will then use to create invoices etc.

Once I have that done, my next goal is to make it so, after browsing through the customer details, if i press "create order button" it will open a new order and automatically place their name into the customer id field - perhaps it looks a bit wrong with all these numbers and lack of proper entries - maybe i shud swap it so the number is in the background and the name or product name etc. is the first thing you see.

Thanks guys

From a beginner at access =]

 

[Galaxiom]

Redesign your subform on a query that joins order and product tables on [Product No] so all the required fields are showing in the form.

Make a textbox in the footer of the subform with the Control Source: = Sum([costfield])