Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2004
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter (Access 2000)

    Hello all,
    I would like to know if there is a way to in a query when a user is prompted for an entry that instead of the user entering a value into a textbox that a combobox would be available for them to make a selection from. Or should I just build a form and have the selection on the form be passed as criteria to the query. I appreciate any answers I may recieve.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Parameter (Access 2000)

    I would build a form with a combo box on it.

    I don't believe you can put a combo box into a parameter prompt any other way.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Parameter (Access 2000)

    The "standard" way to do this is to create a form with a combo box. You can refer to this combo box in the Criteria line of the query as

    [Forms]![frmSelect]![cmbDropdown]

    where frmSelect is the name of the form and cmbDropdown is the name of the combo box.

  4. #4
    Star Lounger
    Join Date
    May 2004
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter (Access 2000)

    Thanks everybody. I thought that was probally the best/only way to go. Just thought I would check to make sure.

Posting Permissions

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