Automatically Calculate fields on a form

[alinka]

Hi,

On a FORM, I have 4 fields which ask for numbers to be entered into them.

I have a 5th field in which I want the total of the above 4 fields to be automatically inputted. How do I do that? It's probably putting a SUM formula into the properties of the 5th field, but I tried it and it didn't work. I put =[field1]+[field2]+[field3]+[field4] but that doesn't work.

Could someone please help me with how this 5th field can automatically display this TOTAL of the 4 fields above. Thanks soooo very much!

 

[Dugantrain]

Is this a field that will be captured in an underlying table or just something that you want to dynamically view?

 

[alinka]

Dear Dugantrain,

Thanks for your response. I will definitely want to capture the "total" field in the underlying table..., while still displaying the "total" on the form. Hope this helps.

 

[Dugantrain]

You'd need to do some coding. Here's one way to do it
Field1_AfterUpdate()
Call MyFunction
End Sub

Field2_AfterUpdate()
Call MyFunction
End Sub

Field3_AfterUpdate()
Call MyFunction
End Sub

Field4_AfterUpdate()
Call MyFunction
End Sub

MyFunction
Field5=Field1+Field2+Field3+Field4
End Function

 

[alinka]

Dear Dugantrain,

Thanks again for helping. I am a beginner access user. Could you please kindly tell me where I put this code? I don't really know where to put it. Thanks so much!

 

[Dugantrain]

-Go to design view
-Select the code icon from the toolbar(it's the icon with the green, yellow, and red points).
-You'll now be in the code window,where you'll write your code. Don't just copy and paste what I gave you, though, you'll need to give the subs the same name as your textboxes on your form. I understand that making a first foray into code can be confusing; if you can't get it to work, then post back and I'll help you.

 

[alinka]

still need prepopulating help

Hi again!

I tried inserting code, but code a code "variable" error. I think I'm inserting it the wrong way, even though I followed instructions.

May I email you my form so that You see what it looks like?

-Alina