Totals

[Xander117]

Okay I know there has to be an easy way to do this. I have a subform, that allows the user to enter in the type of error (Combo),number of errors(number), comments (memo), and type of testing (yes/no). Everything works great except for the fact that in order to get my total line for number or errors to work I have to refresh. There is a master/child relationship between like fields on the form and subform.

Is there an on click command or anything really that I can use to get it to refresh my total line as the user adds in errors? I tried doing an on-click macro to refresh, that didnt work. I want to be able to use this line to feed some calculations, and dont want to have to tell them they have to hit refresh before it works right.

 

[Montez659]

In the subform you can include something like the following if the formula is the control source:

 Private Sub myControl_LostFocus()
Forms!MainForm.Recalc
End Sub

Or else, you could just modify it to do the calculations in VBA. Check out this link to see how communication between main and subforms occurs:

http://access.mvps.org/access/forms/frm0031.htm