Problem with Amount Field

[coolcatkelso]

Hiya

I'm trying to add an Amount Field into my customers form, so I can sum all off the workorders in the customers name and have the total displayed in the customer form.

Have tried all sorts of things but to no avail.

Can someone take a look at this?

The main should open itself. Workorders by Customer

Workorders By Customer (Main Customer Form) This is where I want to display the Amount Due)

Workorders is where the materials, labour etc is stored

Been trying this for months now

Cheers
CCk
________
Ipad accessories

 

[RuralGuy]

Your SubForms are properly based on queries so you could add a field that extends the value of each record to the query. Then in the footer of each SubForm you can place a TextBox that sums the extended fields. This control is not visible in Datasheet mode but you can reference it in code. So put a TextBox on your MainForm that references the SumTextBox so it will display on your MainForm.