Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: Run Macro on Query Close


    How can i run a macro or event when a query is closed?

    I want to minimise my main menu when i click the query button and then restore the main menu when the query is closed.

    On forms and reports i have placed buttons linked to macros to do this, but you can't put a button on a macro.

    Is there a way to put an onclose event on a query so it opens the main menu form when closed?

    Asset Names
    Form - Main Menu
    Query - Document Query


  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    You can always embed the query in a form, and then use the form's events to handle whatever code you want to run.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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