Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Oct 2006
    Location
    Melbourne, Victoria, Australia
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combo boxes (2003)

    Hi all, I have 4 combo boxes on a form, each of which has the same list choices. I would like to design them such that if the user selects "palliation" (for example) for the first combo box, the choice "palliation" would subsequently not appear in the next 3 combo boxes. Can this be done? Regards, Van

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combo boxes (2003)

    What is the Row Source Type of the combo boxes? 'Table/Query' or 'Value List'?

  3. #3
    2 Star Lounger
    Join Date
    Oct 2006
    Location
    Melbourne, Victoria, Australia
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo boxes (2003)

    Value List

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combo boxes (2003)

    You could rewrite the value list of the next one in the After Update event of each combo box.
    If the user selects the combo boxes in an arbitrary order, it becomes confusing.

    See the attached demo for possible code.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Oct 2006
    Location
    Melbourne, Victoria, Australia
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo boxes (2003)

    thanks muchly Hans
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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