Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    413

    Unanswered: Run Query using a menu

    I have a database that opens using the addmenu macro's so I have a File Menu and so one just like in a normal program. It opens the main form when it loads. How do I run a query and enter the criteria I want and then make it run?
    The query is named qry_find
    I tried using a macro and even a form and I can enter my criteria but no way to make it execute.

  2. #2
    Join Date
    Aug 2012
    Posts
    31
    Sounds like you close. If your excuting the query from the form menu you can either have the query prompt you for the criteria by just using something like [enter date] in the criteria field of your query. Or you enter something like:

    forms[yourformname]![textboxname]

    In the criteria field so it looks to the text box on the form for the criteria.


    If I'm way off you can post more detail about what your doing. Either way when the query runs it should look for the criteria. If the criteria is there it will finish if it's not, it'll usaully finish anyways, just wiht the wrong data.

Posting Permissions

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