Dynamic Access Table from Form

[mwemyss]

I am tyring to write a query where Admission numbers to a club will be selected from different tables depending on the members start year. All the options for the year tables are in a drop down combox on a form. I want a user to be able to select a year from the box, then the query to select information from that year table.

Hope that make sense, here is the code I have been using. It says syntax error:

SELECT [Admission No#]
FROM [Forms]![Control Form]![YearSelect];