Invoice Form

[BobMcL]

Since I posted my system last time I have started my system again because it was seriously messed up. I have now come to a point, like last time where I have a problem with the total on my Invoice/Order form and also i dont know how to use all the data from a 'created order' and make it into a report invoice to print off. Any help appriciated.

My system:
Gamez New System

 

[ansentry]

Put this in the query that runs the sub form;

ExtTotal: [UnitPrice]*[Quantity]

Now put ExtTotal on your subform as a control.Change its name to txtExtTotal

Create an unbound text box on your subform name it txtsfrmTotal put this
as the control source;

=Sum([ExtTotal])

On your main form put an unbound Text Box (give it a name), for its control source enter;

=[Order Form Subform].Form!txtsfrmTotal