Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    21

    Unanswered: Basing a combo box, on the result of another combo box

    I have 2 tables, supplier and supplier contact.

    One supplier can have many contacts (employers)

    On my form, I want the user to be able to select the suplier, and in the second combo box, I only want it to display the workers for that employer.

    Example.
    Supplier:
    Microsoft

    Employers:
    Andy
    James

    Supplier:
    GenToIT

    Empolyers:
    George
    Derick

    If I select Microsoft in the first combo box, in the second, I only want Andy and James to be avalaible in the list.

    Thanks

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoSupplierEmployersA2003.mdb" (attachment, zip).
    Look at Form (VBA), Query, Tables, Relationships.
    Open Form and try. Adapt it in your mdb.
    Attached Files Attached Files

  3. #3
    Join Date
    Sep 2012
    Posts
    21
    Thankyou very much, I will have a look at that when I am on a diffrent computer and can open .zip files and will let you know if it has solved my problem.

    Thanks again

Posting Permissions

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