Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Location
    Australia
    Posts
    23

    Unanswered: Run Macro on Query Close

    Hi,

    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

    Thankx

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    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.

Posting Permissions

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