Hi everyone. I would like the below code to include a command that clears the form ready for a new record after refresh. There is a "AddRecord" button but data entry would be made faster by a code.
Code:
Private Sub Remarks_Exit(Cancel As Integer)
DoCmd.RefreshRecord
DoCmd.GoToControl "NameOfOwner"
End Sub
Private Sub Year1_Exit(Cancel As Integer)
If [Status] = "CURRENT" Then
DoCmd.RefreshRecord
DoCmd.GoToControl "NameOfOwner"
End If
End Sub
Would somebody else please insert the appropriate code. Thank you.