MS Access-How to make a query or form(?) select among different tables?

[diode]

Hello,

I want to write a report or form or something in which you can specify a year or table name, and then it goes and searches that table for that year. I took Access in college several years ago, but we never designed anything that let you type in data that the report or form used in order to determine which table to search. I was thinking about using a combo box or list box and then put in the years in that so it knows what to select. The place I work for wants me to do this, and I'm not even sure it's possible.

I hate to make this topic because the board is MSSQL, but that was the closest I could find here. Sorry about the inconvenience.

But anyway, I googled, searched the Help in Access, and all resources at my disposal, but I am not finding anything, and I was wondering if anybody knew anything about this.

Thanks lol :)
diode

[diode]

Oh I forgot to add this. The problem seems to be that the query has to be able to take information or parameters from the criteria you choose so it knows which tables to select from and join.

Thanks :)
diode