I'm currently building a new form and am unsure how to do the following -
Depending on what option I choose within ComboBox1 I want only certain data available in ComboBox2.
i.e. If I selected 'Day of week' in Combo1 I would only want 'Monday', Tuesday' etc available in combo2. But if I selected 'Month' in combo1 then I would only want 'Jan', 'Feb', etc available in Combox2.
I'd be very grateful if anyone has ideas on how I can do this.