Calculation field in form

[ste_pie87]

Can somebody please help me, I'm relatively new to MS Access

I have attached the db i need help with

There are two tables and two forms linked to those tables

The issue that im having is that i can't seem to get the fields to calculate within the form. The change box for each question in the form should equal Post Score - Pre Score. I have tried everything and can not seem to do it



Please help

[rommelgenlight]

since your textbox "change" are bound to change_question control source you maybe in difficulty using (=[post_question1]-[pre_question1]) in your default value of the textbox. what you can probably do is use the EVENT PROCEDURE like AFTERUPDATE or LOSTFOCUS.

If you use after update event procedure it goes something like this:

a. Using the Pre_Question1 textbox:

Private Sub Pre_Question1_AfterUpdate()
me.Change_Question1.Value=me.Post_Question1.Value-me.Pre_Question1.value
me.overall_change.value=me.change_question1.value+ me.change_question2.value+so on and so forth.
End Sub

b. Using the Post_Question1 textbox:
Private Sub Post_Question1_AfterUpdate()
Me.Change_Question1.Value = Me.Post_Question1.Value - Me.Pre_Question1.Value
me.overall_change.value=me.change_question1.value+ me.change_question2.value+so on and so forth.
End Sub

study how it works. this is just a simple way for you as a beginner. as you go on you can also study how to use DIM statement. research for it.