Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hi all<br><br>I am wanting to (Access 2000 SR1)

    Hi all

    I am wanting to have a form with 2 buttons on, one calls a module which "massages" data for reports and the other a a Cancel button.

    Is there a way to set it that I only have to have some code in one place, that once it detects that the Cancel button (or a specific keystroke like the ESC key) has been pressed that it then runs another module/subroutine or goes to a specific label in the subroutine?

    Thanks

    James

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hi all<br><br>I am wanting to (Access 2000 SR1)

    Why not separate out the labelled portion of your code as a function or sub and call that instead of going to a label. You would then be able to call it from both the code and the cancel button.

Posting Permissions

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