Results 1 to 3 of 3

Thread: Message Box

  1. #1
    Join Date
    Mar 2008
    Posts
    8

    Unanswered: Message Box

    I am trying to set up a message box to pop up automatically when typing into a certain column any cell.

    MsgBox "Please verify this is the next check in the sequence before adding the check information", vbOkOnly

    When I enter the check number this does not pop up - can anyone help?

  2. #2
    Join Date
    Mar 2008
    Posts
    8

    Message Box

    Please disregard this post - I wanted this to post in Excel

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    'Columns' and 'Cells' are Excel terms. In Access you would speak of Fields and Records. Assuming this is an Access question, where is your code placed?

    This should do the job:
    Code:
    Private Sub CheckID_BeforeUpdate(Cancel As Integer)
      MsgBox "Please verify this is the next check in the sequence before adding the check information", vbOKOnly
    End Sub
    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
  •