I have figured out the problem, It seems a RecordSetClone will clone the data but obviously not the actual controls in the continuous form. Im not sure why exactly this works but here is new code:
Code:
Private Sub Form_Load()
Dim rst As Recordset
Set rst = Form.Recordset
rst.MoveFirst
While Not rst.EOF
If depositPaid = -1 Then
MsgBox ("Check")
End If
rst.MoveNext
Wend
End Sub
Here the only change needed was the line
Code:
Set rst = Form.RecordsetClone
Which was changed to
Code:
Set rst = Form.Recordset
Thank you for your help however, it does help me to think outside of the box a little with a different perspective.
Much Appreciated