Originally Posted by
Ganymede
I need to make it so that when they select the year, that will determine which of the 19 tables that the crosstab query looks at.
Table and field names in query object cannot be dynamic (well, CROSSTAB column headers are exception). Requires VBA and QueryDefs collection to modify query structure. Code could change form or report RecordSource property SQL statement. So if you can design CROSSTAB to be stable (always same column headers), could base a form or report on that structure and use code to change RecordSource to reference selected table as source.