Calculated field..from sub-form (1 Viewer)

[mcclunyboy]

Hi,

I am trying to subtract 4 fields from each. These are "totals" within a sub-form.

On the main form want to take 1 of those fields and subtract the other three. For some reason I keep getting the #!type error after I include more than one text box. Any help would be appreciated:The following is basically what I have:

[sub_detail]![text43]-
[sub_detail]![text27]-
[sub_detail]![text43]-
[sub_detail]![text27]

Eventually I will need to take the calculated figure and assign it to the right field in the record source but I'd like to get the right value first.

Thanks

 

[maw230]

Not sure if im reading this right, but I think I would use a query to make those calculations.