Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    On change question (Access 2k)

    I am working on a form that has a date field called

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: On change question (Access 2k)

    This works for me

    Private Sub Field1_AfterUpdate()
    MsgBox ("you have changed the date")
    End Sub
    David Grugeon
    Brisbane Australia

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: On change question (Access 2k)

    OnChange occurs for every keypress in the control, so you don't want to use that. The AfterUpdate event of the control bound to Start is the appropriate place to call the msgbox function. Post what you've tried and someone can help you make it work.
    Charlotte

Posting Permissions

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