Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    29

    Unanswered: combo box problems

    I feel very silly asking this, as I'm sure the answer is right in front of me. I have a form where the user can select 3 different vendors to compare their products. I am using combo boxes to select the vendors from the drop down list. The problem is that when I change 1 vendor, the other 2 change as well. The vendor field in the table is a drop down list. I have tried changing the combo box and row source, it's still not working.

    How can I do this?

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Are you using the same query for each combo box? If you are then for each combo box click on the three dots ... to the right of the row source to build your data source.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I suspect the combo boxes are all bound to the same field.
    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

  4. #4
    Join Date
    Feb 2009
    Posts
    29
    Each combo box is a drop down list based on my Vendor table, which lists all vendors. I used unbound combo boxes, thinking they would be separate, as opposed to dragging the field in from the list of available fields. Is there a way to have each drop down list hold the same values, without being bound to the same field?

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, bind it to different fields.
    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

Posting Permissions

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