I'm confused! What is the point of having a
Checkbox Control that
has to have one and only one given
Value, i.e has to be equal to
True/Yes/-1, before the
Record can be
saved?
That aside, you have to
Cancel the save before returning
Focus to the
Checkbox. in general terms,
Validation code to check
Controls before
saving a Record should be something like this:
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.CheckboxName <> -1 Then
MsgBox "CheckboxName Must Be Ticked Before Saving Record!"
Cancel = True
CheckboxName.SetFocus
Exit Sub
End If
End Sub
Linq
;0)>