Change values in combo box after selection

[rwahdan1978]

Hi



I have 2 combo boxes that has values from users table. after choosing a user in the first combo box I need to update the second combo box to have all the other users (removing the selected user that we chosed from combo 1).

Example:

combo 1 have: Sam, Adam, Mike and I choose Mike
combo 2 will get updated and only have Sam and Adam

I need to do that programatically.

Thanks

[Welshgasman]

In the afterupdate of combo1, set the source of combo2 to be your fields and criteria WHERE ID <> comboID
Replace the names to suit.

[Micron]

This is known as cascading combos. You might want to look it up as you might find it comes in handy for other things.

[CJ_London]

In addition to Welshgasmans comments - I would also remove any value that may be in the second combo as it will remain until the user chooses a valid one. e.g. original value in 2nd combo for Sam (list A, B, C) is A. User changes Sam to Adam in the first combo and the 2nd combo list becomes B, D, E. A is not in that list but will still be the value in the combo until user selects a valid one.

[Micron]

Isn't that part of most posted code for cascading combos? I can't recall as it's been some time since I read anything on this subject. The AfterUpdate event of a parent combo is supposed to include a requery of the child combos. At least I think that's what posted code does. Of course, that assumes the list items are based on a query and not a value list.

[CJ_London]

Isn't that part of most posted code for cascading combos?

depends on the link you find. Some are better than others and makes a difference whether the form is single or continuous