Results 1 to 3 of 3
  1. #1
    ManC is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    22

    User Input Query


    Hi.
    I need help!!
    I have two combo boxes and a button on my form. One combobox is for company name and the other for product.When the user selects a company (For e.g. IE) and a product (For e.g. Server), on command button click the list of servers for the particular company are displayed in datasheet view. I have achieved this goal.
    My problem is how to display all the products for a particular company. Say, If i select a company name and write 'ALL' in the product combo box, all the products for that company need to be displayed.
    Simply put,I need to check in the query if the text entered in the combo box is 'ALL'.
    How do i achieve this?Is it possible?
    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I would use this technique:

    http://www.mvps.org/access/queries/qry0001.htm

    perhaps along with this one:

    http://www.mvps.org/access/forms/frm0043.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    ManC is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    22
    Thanks for the solution.
    I solved the problem yesterday by making use of IIF statement in the sql query.
    Thanks

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

Similar Threads

  1. Replies: 3
    Last Post: 08-25-2010, 09:03 AM
  2. Chart with user input
    By mungyun in forum Access
    Replies: 1
    Last Post: 12-28-2009, 07:44 PM
  3. Creating input box for query
    By dcecil in forum Queries
    Replies: 1
    Last Post: 06-23-2009, 10:08 AM
  4. Replies: 0
    Last Post: 01-18-2007, 07:07 PM
  5. Set required user input
    By ZeusOsiris in forum Database Design
    Replies: 2
    Last Post: 12-04-2006, 07:13 PM

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