Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: Drop down menu for Query parameter

    Is it possible to do a drop down menu for the query parameter? How to do it?
    So the user just choose one of them as parameter to run the query.

    Thank you

  2. #2
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154
    greets;

    the best way to do this would be to create a new table, eg: tbl_criteria, and create a lookup field in this that you wish to be the criteria, for this example, we shall use months;

    field months; Jan;Feb;Mar.. and so on

    create a query, and in this query add in the table you wish to set the criteria for, add in the tbl_criteria too.

    Create a link from the field in tbl_criteria (months) to the corresponding field in the other table (for this example it would have to be a month too)

    Whatever month is then selected in your table, the query will filter results based on this and show them only.

    Hope this helps,

    Dan
    sometimes simple is best.... and i'm just a simple fellow.

  3. #3
    Join Date
    May 2006
    Posts
    5
    thanks Dan,

    I got an idea from your clue

    cheers

Posting Permissions

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