Table Selection Combobox

Hello All,

I am new to access I am trying to build a combo box that would prompt the user to select a table and then apply the selected table to a report.

Is that possible?

For example the tables would be June Sales/ July Sales/ Aug Sales etc. If the user selects Aug Sales then the control source for the report would use that table's information. Any help would be greatly appreciated.

Thanks

If all the tables are identical, then they probably should all the in the same table with a field for the period. All you should need to do is select the desired period from a combo box.

The report's query can reference the combo box on the for to get the criteria.

I have never had the need to do this with all the databases I have created.

If you really wanted to do what you ask, then the only way this will work is if all the tables have the same exact design. ( **** If they are all the same, this indicates that is should be a single table, not multiple tables).

I would use a form to select the desire table. Once selected use VBA code to modify the Query Def for the report to the SQL to select he desired data. Once the query has been updated, then you can open the report.

Note: If designed properly, all you would have to do is select the desired period from a form using a combo box. The report's query can reference the combo box on the for to get the criteria.

example form reference:

forms!frmGetPeriods.cboPeriod