Allowedits on On Current form event

[daninthemix]

Hello all!

I have this code in a form's Current event:
----------------------------------------
If ChkClosed.Value = Checked Then

AllowEdits = True

Else

AllowEdits = False

End If
----------------------------------------

Simple eh? ChkClosed is a checkbox sourced by a field with a "yes/no" datatype. For some reason it always uses the 'Else' code. In other words, it's not actually bothering to check the status of ChkClosed which seems pretty rude to me.

Any suggestions?

Thx

 

[Rich]

If ChkClosed Then

AllowEdits = True

Else

AllowEdits = False

End If

 

[ghudson]

-1 = True/Yes
0 = False/No

If ChkClosed = -1 Then

     Me.AllowEdits = True

Else

     Me.AllowEdits = False

End If

 

[MarkK]

Me.AllowEdits = chkClosed

 

[daninthemix]

Thanks chaps.