I have several combo boxes on a form that have various tables as their row source. What I would like to be able to accomplish is that when a user selects a value from the combo box, it is no longer available for selection on the next record. For example, if my combo box list contains:
Hats, Mittens, and Boots
and a user selects Hats on the first record, on the next record only
Mittens and Boots should show on the combo box drop down list.
Is this possible and if so, how would one go about doing it?
Thanks in advance for any assistance.
Hats, Mittens, and Boots
and a user selects Hats on the first record, on the next record only
Mittens and Boots should show on the combo box drop down list.
Is this possible and if so, how would one go about doing it?
Thanks in advance for any assistance.
