I am writing a subroutine using the Event function. I want it to put "insurance" into the field "ReasonNC" and then check the field "ClosedYN." Here is what I wrote:
Private Sub cmdInsurance_Click()
On Error GoTo Err_cmdInsurance_Click
Me.ReasonNC = "Insurance"
Me.ClosedYN = "-1"
Exit_cmdInsurance_Click:
Exit Sub
Err_cmdInsurance_Click:
MsgBox Err.Description
Resume Exit_cmdInsurance_Click
End Sub
The Me.ReasonNC = "Insurance" works (when I isolate that command) but I get an error when I try to "check" the field "ClosedYN." What is the correct format to "check" this field? I know it is something simple, but I just can't find it in any of my references.
Thanks!