[AccessD] Check Only One

Hollis, Virginia hollisvj at pgdp.usec.com
Mon Oct 23 12:19:40 CDT 2006


Great! Thanks.

 

One more question & I will leave you alone.... How do you refer to the
checkbox in the frame?  I tried me.chk5 = True & I also tried me.chk5 =
1. Neither one worked. I get an error.

 

Private Sub fraNature_AfterUpdate()    

  'If choice is Other, enter data in field

    If (Me.chk5 = ) And (IsNull(Me![Other])) Then

        MsgBox "You must enter the reason", _

        vbInformation, "Complete Field"

        Other.SetFocus

    End If

End Sub




More information about the AccessD mailing list