Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2008
    Posts
    4

    Red face Unanswered: drop down search

    I have a large table of various work done by several persons. I need to list for a report all the work done on occasions by one person. All the persons can do any of the work. I am using a combo box with all the persons names on but cannot get it to list the work done by one person. the fields are 1, name, 2, date, 3, work done.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Microsoft Access?

  3. #3
    Join Date
    Jun 2008
    Posts
    4

    drop down search

    yes Microsoft Access 2007
    Last edited by merrymerry; 06-23-08 at 16:10.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Let me get my crystal ball...

    Seriously... more information is required.

    No table name to work with.
    Name of the form with the combo box to select from is missing.
    Name of the combo box control being used to select the person is missing.

    Best I can come up with is:

    SELECT * FROM sometable WHERE [Name] = forms!someform!somecbocontrol

    BTW:
    Name is a reserved word.
    Date is a reserved word.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jun 2008
    Posts
    4

    drop down search

    the table at the moment is just "table1". I put the combo box which lists the names fields in a form called "search" and I have called the combo box just"combo1" Hope this is useful
    and thanks for the interest, I have difficulty with understanding the way access wants to work!

  6. #6
    Join Date
    Jun 2008
    Posts
    4
    Thanks guys, I have now resolved my problem.
    It just needed a bit more thought!!!!!!!!!

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Care to share how?
    George
    Home | Blog

Posting Permissions

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