Calculated control help

[cici]

I'm trying to add a calculated control to a custom form to add together two other fields in the same form. I used =Sum(Field1+Field2) in the Control Source on the Property Sheet. It works in adding together the two fields. However, rather than just adding the two fields on the current record, it totals those two fields on all of the records in the form. I have 46 records in the form and I want it to just add the current record and then change numbers if I click over to another record. How would I go about doing this? Any help is greatly appreciated

[Access_Blaster]

Hi cici,

Are you using a form/subform? or a form?

[cici]

It's a form. All the fields and formulas are in the one form, no subforms or linking to other forms or anything.

[Access_Blaster]

Hi cicic,

If field1 and field2 in your table are set to number "Long Integer"
Place the below code in a text box's control source.
Post back if you need more help.

=[field1]+[field2]

Richard

[cici]

That worked perfectly!! Thank you so much!!