Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Thanked 0 Times in 0 Posts

    Drop down box on query (Access 97)

    Hi, When writing a query I am puting the criteria in the appropriate box each time. However, is it possible to have a drop down box here which displays the criteria instead of having to type it in all the time.

    Thanks for your help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Drop down box on query (Access 97)

    Welcome to Woody's Lounge!

    Do you mean that you would want to have a dropdown box for criteria in query design view? If so, the answer is no, as far as I know. What would you expect the dropdown box to display?

    If you mean that you have created a query with a parameter, so that you are prompted for a value when you open the query, the answer is still no, but you can create a form with a combo box (the "official" name of a dropdown box) and use the value of the combo box as query parameter. Instead of something like [Enter city here], you could have [Forms]![frmSelect]![cbxCity] - this refers to the value of a combo box named cbxCity on a form named frmSelect. The form must be open for this to work, otherwise you'll be prompted for a value.

    Feel free to post back if you would like more information.

Posting Permissions

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