Results 1 to 2 of 2
  1. #1
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29

    Pull down menu at run time in queries

    Hi all

    I want to add a pull down menu in the query, so that at run time I will be given the option to


    chose a value from that pull down object .

    That value will be serve to change the chosen rows of the query at run time.

    how is that done ?

    Thanks
    Elico

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    build a form, put a combo box on it.
    the user picks an item, then opens the query.
    the query will use the combo box as the criteria

    select * from table where [State]= forms!frmRpts!combo1

    you must use the NAME of the combo box. Use the BUILDER to help in the query design.
    above the combo is called combo1

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

Similar Threads

  1. Replies: 3
    Last Post: 11-19-2013, 11:48 AM
  2. Replies: 1
    Last Post: 10-15-2013, 10:41 AM
  3. Replies: 5
    Last Post: 11-15-2012, 09:53 AM
  4. Need single report to pull from 2 queries
    By Nathan Plemons in forum Access
    Replies: 2
    Last Post: 03-14-2012, 11:04 AM
  5. Replies: 1
    Last Post: 03-07-2011, 10:48 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