Setting the value of a "checkbox"

[sueb]

I'm trying to set a checkbox field in my table based on what the user enters into another field. The following code does everything right (display the box as the user leaves the field, accept the click and disappear) except actually set the checkbox value. I don't get an error. Am I using the wrong value for "Yes"? Or what?

Private Sub Category_AfterUpdate()
On Error GoTo Err_Category_AfterUpdate

Dim myVAR As Byte

'Make the user specify whether this IUR needs Radiology's signature
If Me.Category.Value = "MRI" Then
mVAR = MsgBox("Does Radiology need to sign this?", vbYesNo + vbQuestion)
End If

'If so, set the tag; otherwise, do nothing
If myVAR = vbYes Then
Me.Rad_Sig.Value = -1
End If

Exit_Category_AfterUpdate:
Exit Sub

Err_Category_AfterUpdate:
MsgBox Err.Description
Resume Exit_Category_AfterUpdate

End Sub

Thanks!

[TheSmileyCoder]

Assumming the code is a direct copy/paste, its because you have a typo.
mVar should have been myVar

mVAR = MsgBox("Does Radiology need to sign this?", vbYesNo + vbQuestion)

Please read this article, it will save you ALOT of headaches!
Require Variable Declaration

Also when posting code, please remember to use the [code] . . . [/code] tags around your code.

[sueb]

Is my face red! I guess that's what I get for working too late too many days in a row.

Now it's perfect--thanks for catching that!