Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    21

    Unanswered: Criteria in a query

    I want to set a criteria on an account field of my query. Currently in criteria I have [Account Name:]. Is there a way to create a pop up with a list of accounts instead of manually entering it, and if so how is it done?

  2. #2
    Join Date
    Oct 2007
    Posts
    21
    ok, I'm trying something different. I've created a form with a listbox of the account names, but I am having trouble linking it to the criteria. I have the query criteria set to =Forms!frmAccounts!Listofaccounts but all I get is a parameter popup asking for exactly that.

  3. #3
    Join Date
    Oct 2007
    Posts
    21
    is the problem in the total? I have it set to "group by"

  4. #4
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    I have the query criteria set to =Forms!frmAccounts!Listofaccounts but all I get is a parameter popup asking for exactly that.

    So... you have a form whose recordset's source is a query, right so far?

    And you want that query to choose records based on what the current value of Listofaccounts is?

    This is a little bit irritating to do in Access.

    Try this or this.

Posting Permissions

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