Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    45

    Unanswered: Reupdating Comboboxes after selection

    Hello,
    I am wondering in MS Access 12 and regular access, how to make a combobox autoupdate.
    Example:
    I have 5 employeess
    Tom
    Frank
    Ricky
    Ken
    Jeremy

    I want to have a set of combo boxs on the form.
    When I click on any combobox not nessecarily the first one, and select lets'say Frank
    Now when I would click on another combobox All the names would come up except for Frank.
    Then I would select Lets say Tom
    And when I go to another combobox Franks and Tom's name isn't listed.

    and so on

    is this possible and how would I go about doing it?
    I have another idea but I'll wait to see if this can be done first.

    Thank you Paul

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Quote Originally Posted by ArnMan
    Hello,
    I am wondering in MS Access 12 and regular access, how to make a combobox autoupdate.
    Example:
    I have 5 employeess
    Tom
    Frank
    Ricky
    Ken
    Jeremy

    I want to have a set of combo boxs on the form.
    When I click on any combobox not nessecarily the first one, and select lets'say Frank
    Now when I would click on another combobox All the names would come up except for Frank.
    Then I would select Lets say Tom
    And when I go to another combobox Franks and Tom's name isn't listed.

    and so on

    is this possible and how would I go about doing it?
    I have another idea but I'll wait to see if this can be done first.

    Thank you Paul



    Sure,

    One way would be to set the combo rowsource's dynamically like:


    "Select * from yourLookUpTable where yourLookUpTable.firstName Not In ('" & Me.yourComboBox1 & ", '" & me.yourCombobox2 & "'"


    You would want to set the rowsource in the combo's "onEnter" event.

Posting Permissions

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