B
bcasper
I have two combo boxes that are pointing at two different
fields of the same table. I want one combo box to filter
the selections available from the other combo box. It
works for the first time for the selection of the second
combo box but if I change the data of the first combo box,
the second combo box will not adjust with it. Example:
Field1 Records: Colors, Colors, Numbers, Numbers, Letters
Field2 Records: Green, Blue, Two, Four, Q
If Combo1 is based on Field1 and I set it to "Colors",
then when I move to Combo2 that is based on Field2, I have
the option of selecting "Green" or "Blue". What I want to
happen is if I move back to Combo1 and change it
to "Numbers", I only want "Two" and "Four" to show up as
selections available. What can I do???
fields of the same table. I want one combo box to filter
the selections available from the other combo box. It
works for the first time for the selection of the second
combo box but if I change the data of the first combo box,
the second combo box will not adjust with it. Example:
Field1 Records: Colors, Colors, Numbers, Numbers, Letters
Field2 Records: Green, Blue, Two, Four, Q
If Combo1 is based on Field1 and I set it to "Colors",
then when I move to Combo2 that is based on Field2, I have
the option of selecting "Green" or "Blue". What I want to
happen is if I move back to Combo1 and change it
to "Numbers", I only want "Two" and "Four" to show up as
selections available. What can I do???