Linking two Access listboxes

A single listbox is a good way of letting users select an entry from a table. Sometimes though, users' requirements are more complex and they need to be able to make the selection in two stages. The sample form below shows one list box showing a choice of courses and a second box showing the dates when the selected course is running:

Two simple changes synchronize the two listboxes.

The first is to set the RowSource of the right-hand listbox:

The second is to make sure that the right-hand list box is updated every time that a new selection is made on the left. Put this code into the Click event of the listbox:

This works because the Click code runs whenever the user changes to a new row in the list box - regardless of whether the change is made by a mouse click or the cursor keys.