Hi Everone
I have a form and have a Yes/No Box in it.
What I want to do is I have entered an Event Procedure On Exit where if I have the Yes clicked I want to update the data and exit the form else if it not clicked to go to the next record on the form. I tried the following code:
Private Sub NOTPAID_Exit(Cancel As Integer)
If ([NOTPAID] = "YES") Then
Me.Update
Close
Else
DoCmd.GoToRecord , , acNext
End If
End Sub
....but it does not work ....can anyone help...Thanks !!!!
I have a form and have a Yes/No Box in it.
What I want to do is I have entered an Event Procedure On Exit where if I have the Yes clicked I want to update the data and exit the form else if it not clicked to go to the next record on the form. I tried the following code:
Private Sub NOTPAID_Exit(Cancel As Integer)
If ([NOTPAID] = "YES") Then
Me.Update
Close
Else
DoCmd.GoToRecord , , acNext
End If
End Sub
....but it does not work ....can anyone help...Thanks !!!!
Last edited: