Thanks for your help!!
I have done the addition now in my code and that seems to calculate it instantly and then it displays an error message.
My next problem is after the error message has been OK'd I want the cursor to move to the previous field but when I say Me.recordset.moveprevious it doesn't seem to work.. don't suppose you know why this maybe? I have pasted my code below:-
Code:
Private Sub Placement_Split_AfterUpdate()
Dim dSplitCntr As Double
Me.testbox1.Requery 'testbox is just so that i can see in the form whether the calc is working
Forms!Fm_SubForm.Recordset.MoveFirst
Do While Not Forms!Fm_SubForm.Recordset.EOF
For Each Item In Forms!Fm_SubForm.Controls
If Item.Name = "Placement Split" Then
dSplitCntr = dSplitCntr + Item.Value
End If
Next
Forms!Fm_SubForm.Recordset.MoveNext
Loop
Me.testbox1.Requery
Forms!Fm_SubForm!testbox1 = dSplitCntr
If dSplitCntr > 1 Then
Response = MsgBox("Error", vbOKOnly)
Me.Recordset.MovePrevious
thanks!