ListBox selection and disable

[johnseito]

How do you make the second list box highlight the value base on the selection of the first list box because of the only choices available base on the selection of the first list box and vice versa.



For example: we have month 7, 8, 9, and 10 in the first list box. In the second list box we have 2012 and 2013.

But 7,8 have 2012 and 9, 10 have 2013.

When we select 7, 2012 will highlight or can be selected but not 2013. When select 9, 2013 can be selected not 2012.

In short how to disable selection base on the other list box selection ? Please advise ?

[June7]

This is called cascading (or dependent) combobox. A very common topic.

[isladogs]

Your combo row source needs to be based on a table / query or sql statement rather than a value list
When you do so, the second combo/listbox will only show the year(s) for which data exists for the selected month.

However, it might be better to swop the order - year in the first listbox ; month in the second ...and if you want ...day/date in a third

[johnseito]

Great, thanks to you both.
I will do and try the combo box but can this also be done with list box ?

[isladogs]

In many respects (but not all), combos and listboxes are interchangeable.
The first listbox can NOT be multiselect for this