Results 1 to 7 of 7
  1. #1
    eagle670 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2014
    Posts
    21

    MultiValue Select Box

    I am wanting to have a multivalue selection box on my form that points to a column in my query, so that I can select the data that I want to run the report on.



    All I have is one query, that contains a sub-category column. This column contains hundreds of sub-categories. On the form I want to select or filter the individual Sub-Categories that I want to run in the query.

    Can someone give me an idea of how to do this?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    It would be MUCH easier to have a pick table to store the items picked by the user. No code. (multi-pick lists require code)
    The query would be linked to it to filter the picks.

    Click image for larger version. 

Name:	pick3-states.png 
Views:	13 
Size:	22.4 KB 
ID:	16847

  3. #3
    eagle670 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2014
    Posts
    21
    I have never done a pick table, can you give me some guidance?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Just make a table to store the users selections (tPicked). (in the picture, the dbl-click event executes an append query to put the state code in the tbl: tPicked.)

    Then when all choices are made, They click a button to open a query like qsClientsInStates. (this has 2 tables joined...tClients & tPicked)
    where tPicked.state joins tClients.State.

    It's a natural filter.

  5. #5
    eagle670 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2014
    Posts
    21
    Forgive me for being an idiot, but I am trying to learn here.

    I have 3 tables, 2 queries, and 1 form that generate my report. The form only controls the final report query at this time. In order for me to filter the report down to what I need, I have to do that in Excel. To do what you are suggesting, do I eliminate the form?
    I am still unclear on how you built the control table, I understand the concept, but I am pretty lost.

  6. #6
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The form allows the user to make his picks. (append qry to tPicks)
    The form ALSO has a button for the final result qry. (a select query, that joins the main data table to the pick list table)

    I dont know what you are picking from.. but it can be a 3rd table or a 3rd qry.

  7. #7
    eagle670 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2014
    Posts
    21
    Thanks for responding, but I don't have any idea of how to do what you suggested. It sounds pretty simple, but I just can't seem to figure it out.

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

Similar Threads

  1. Querry from a multivalue list
    By TOMMY.MYERS668 in forum Queries
    Replies: 6
    Last Post: 08-09-2013, 01:06 PM
  2. Multivalue Field Advice
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 04-30-2013, 07:40 PM
  3. Multivalue List
    By Trojnfn in forum Access
    Replies: 5
    Last Post: 09-30-2011, 12:37 PM
  4. Getting the sum from a multivalue combobox
    By polis in forum Programming
    Replies: 4
    Last Post: 08-31-2011, 03:47 PM
  5. Append into multivalue field help
    By iwantatransam in forum Import/Export Data
    Replies: 0
    Last Post: 04-26-2011, 08:11 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