Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    186

    Unanswered: CHECK BOX AfterUpdate VBA

    I need my after update to trigger if the checkbox is yes.....so I'll use If Then
    I'm sure it's simple but I can't get it to work....I don't know what the language is for YES.....Y, Yes, -1, 1 ? ?

    Private Sub RQTAPPROVED_AfterUpdate()
    If RQTAPPROVED = **blank**, Then
    MsgBox "Approved!"

    Can someone fill in the blank For me?
    Thanks so much!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    If RQTAPPROVED = -1 Then
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2010
    Posts
    186
    Thanks alot!

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You're quite welcome!

    While

    If RQTAPPROVED = True Then

    should work
    just as well as -1, quite a bit of anecdotal evidence says that it doesn't always, so I always go with the -1.
    Good luck with your prokject!Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •