Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: Need help making a Drop List in a query...


    I'm running Access 2003, and am forming a query to use in a customer report in my database.

    My database has several companies that i need to make seperate reports for...but instead of making a seperate query for each and using Companyname* for the result...

    I'd like to have the query provide a list of companies listed in that field...and be able to select one of them to have the query run with that company.

    Any suggestions?

    I know this may be a simple task...but i've yet to find the solution



  2. #2
    Join Date
    Oct 2003
    Try creating a form with a combo box that is loaded with the various company names, the values can be loaded using a query. Then the user can select the desired company in the combo box and then click on a button to run the query. The WHERE clause in the query should point to the value in the combo box on the form to limited records to that company.

Posting Permissions

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