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

    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
    Huddersfield, UK

    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,

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

  3. #3
    Join Date
    May 2006
    thanks Dan,

    I got an idea from your clue


Posting Permissions

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