Results 1 to 3 of 3
  1. #1
    thegrimmerdiscovery is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    30

    Separate queries in a drop list

    Hello

    Is there a simple way of storing several indivdual queries in a drop down on a form? I've currently got several buttons on the form that trigger queries but am looking for a noob-friendly way of making the form look less cluttered. Any response welcomed, the more simple the better

    Thanks in advance

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    you can list the query names using sql

    SELECT [Name] FROM msysObjects WHERE [Type]=5 and left([Name],1)<>"~"

    or you can use a valuelist in your combo to list the queries (see the recordset type property)

    mycombo,rowsource="qry1,qry2"

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    i have a query table
    CAPTION, QRY

    the user sees the CAPTION , but the combo is bound to QRY
    then you run:
    docmd.openquery cboBox

    or assign it to a subform.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-30-2018, 02:56 PM
  2. Exporting two queries into separate sheets on one spreadsheet
    By sam.eade in forum Import/Export Data
    Replies: 2
    Last Post: 07-07-2014, 09:53 AM
  3. Replies: 3
    Last Post: 02-12-2013, 11:26 AM
  4. Replies: 4
    Last Post: 06-16-2011, 09:30 PM
  5. Separate queries?
    By sid in forum Queries
    Replies: 0
    Last Post: 08-01-2009, 10:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums