Results 1 to 6 of 6

Thread: Query Question

  1. #1
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Question Unanswered: Query Question

    Is it possible to have a combo-box/drop down menu for a query? As in a query to see the types of reports done by choosing from a list.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Could you clarify (or expand upon) what you're asking?

  3. #3
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Query

    I would like a combo-box for a person to choose a certain name to run a query generated report on.

    For some reason or other my reports/querys require exact spelling.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Are you asking how to do a parameter query?

  5. #5
    Join Date
    Nov 2003
    Posts
    5

    Re: Query

    Originally posted by jacque427
    For some reason or other my reports/querys require exact spelling.

    If I misunderstand you then I apologize, but here are two (very basic) ways you try to take care of it.

    1) Use a form to transfer the value from the combobox to the query. Create a form with a combobox with your names in it, then you can create a button that will open the report or query. When you build the query you will want to use the following as the criteria:

    [forms]![FormName]![ComboboxName]

    That will pass the information from the combobox to the query. That way you won't have to worry about people using exact spellings, they can select the names from your list.


    2) Use your exsisting query but make the field accept a broader range of searches. Use the following in the Criteria field:

    Like "*" & [Enter the User Name] & "*"

    That way it uses wild cards, and the user can just type the first 3-4 letters of a name, and it will return all the names that begin with those letters.

  6. #6
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Wink Ok Then

    Got it! Thanks so very much!!

Posting Permissions

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