Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    73

    Unanswered: BeforUpdate CancelUpdate Help?

    I have a button setup on a combo box with a before update "If statement".
    If true the user is presented with the msgbox. But what is the syntax for canceling the update? Here is my code.

    Private Sub RMA_ITEM_ID_CONTROL_BeforeUpdate(Cancel As Integer)
    If Me.RMA_OPTION_CBC_CHK.Value = True Or Me.RMA_OPTION_BC_CHK.Value = True Or Me.RMA_OPTION_MC_CHK.Value = True Or Me.RMA_OPTION_MT_CHK.Value = True Or Me.RMA_OPTION_9B_CHK.Value = True Or Me.RMA_OPTION_22B_CHK.Value = True Then
    MsgBox "You must uncheck optional items before changing products", 5, "Caution!"
    End If
    End Sub

    Thanks.

  2. #2
    Join Date
    Sep 2004
    Posts
    161
    ____________________
    Cancel=-1

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by jepi
    ____________________
    Cancel=-1
    ... Or Cancel=[Some # that is not Zero]
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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