Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    44

    Unanswered: Can I set a Condition in a Query from a list box

    I have a form which has one combo and lists text. The user can pick any one from this list. I have a button to open the query dependant on the their choice.

    I also have a query but would like the query to return the results where the condition is the same as the text picked from the combo box.

    It seems that I cannot use docmd.openquery as it does not give me the option for a condition.

    Any ideas

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    in the criteria for your query you could add in
    [forms]![YourFormName]![ComboBoxName]

    but, while editing the query, you may have to go to Query -> Parameters to add in this with the correct data type.

Posting Permissions

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