Automatically updating totals

[CAFCrew]

I am currently trying to develop an access database. I need to build a field that will automatically sum the total of two seperate fields. Has anyone got some code / steps that will help me do this?

Thanks for your help in advance

Cafcrew

 

[Crowley16]

put "= [fldNme1] + [fldNme2]" in the control source of your text box.

fldNme1 and 2 are the names of your text boxes you want to be summing...

--------------------
Procrastinate Now!

 

[CAFCrew]

its returning "#Name?" i have values in both fields i want, and they are both number fields. Any ideas?

Thanks

 

[Crowley16]

that works fine for me...

are you sure you've typed in the correct field names?

--------------------
Procrastinate Now!

 

[CAFCrew]

i typed them exactly as they appeared but it wouldn't work. I am now using the query builder using the same fields and its working!

Thanks for your help

 

[Crowley16]

the names of the text boxes as you've called them on the form...

--------------------
Procrastinate Now!

 

[CAFCrew]

yup. i was just typing the names of the boxes into the source control, but it didn't seem to like it. Its all working now though so thanks very much