Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Parameter Queries

    Hello I am trying to implement a serach function through a parameter query. I would like for the user to choose from a drop down list of current data, instead of having to type in the specific name.

    Is there any possible way of doing this? I am running Access 2000

    Thank you

  2. #2
    Join Date
    Mar 2004
    Tulsa, OK
    Sure -

    1. Populate a ComboBox (we'll call ours 'ComboBox1') on the form with the selections.

    2. Open the Query in design mode, and enter [QueryName]![Fieldname] = [ComboBox1].[value] in the row marked 'Criteria'. I think you can use the Expression builder here.

    3. Use code or macro in the Update event (found in properties) of ComboBox1.
    Thanks in advance or hope this helps.

  3. #3
    Join Date
    Jul 2004
    Great! Thanks for the help.


Posting Permissions

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