I have three comboboxes on a form. I would like for the value options in the third combobox to be dependent on the selections in the first two comboboxes. Comboboxes 1 and 2 will have set value lists, where combobox 3 will vary.
For example:
If I select "red" from combobox 1 and "fruit" from combobox 2, I would like the value options in combobox 3 to be "apple;strawberry;raspberry"
If I select "green" from combobox 1 and "vegetable" from combobox 2, I would like the value options in combobox 3 to be "spinach;lettuce;green beans;cabbage"
Could someone walk me through how to do this? Any help is greatly appreciated!