Complex SQL Statement

Hi. I have a form which has a combobox with a list of events. Below that I want to have a list of the years that we attended that particular show, which may or may not be consecutive. I tried having a table with event ID and year and linking that to the Event ID in the events table and using the resulting SQL as my rowsource for the Combobox but it did not work.

Any suggestions much appreciated