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];
Hope that make sense, here is the code I have been using. It says syntax error:
SELECT [Admission No#]
FROM [Forms]![Control Form]![YearSelect];