DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PLEASE HELP: Trying to create query based on combo box selections

  1. #1
    Join Date
    Jul 2018
    Posts
    1

    PLEASE HELP: Trying to create query based on combo box selections

    Okay, so I just started using Microsoft Access last week and know virtually nothing. I have figured out a lot of stuff but now that I am getting into the SQL I am getting stuck. Currently, I have about 30 queries saved and I need an easy way for a user to select which queries they want to run and find only the records which are present in all of the selected queries.

    I know how to build a query that searches the other queries and displays results the way I want. What I don't know is how to build a form that allows users to do this easily.

    I was thinking it would be best to build a query that searches up to three of the other queries. The queries I want to look through could be selected by a combo box on a form. Then a button would automatically fill in the queries selected by the user and run the main query. Does anyone have an SQL template that I could use to tell access to pull a criteria from a combo box?

    I am sorry if my language is incorrect. Again, I am very new and simply hoping that this is somewhat understandable.

  2. #2
    Join Date
    Jul 2019
    Posts
    1

    Thumbs up

    ok, This is the good question about this topic and I want more information. Please reply to this post...


    **Links removed by Site Administrator so it doesn't look like you're spamming us. Please don't post them again.**
    Last edited by Steve R Jones; 07-06-2019 at 09:33 AM.

  3. #3
    Join Date
    Sep 2020
    Posts
    4
    I think would be better to use checkboxes to select which queries are ran, then run search through resulting table

Posting Permissions

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


Click Here to Expand Forum to Full Width