Rename a table based on a selection in a lookup field of a form

[Tlewman]

I have a form with a dropdown that looks up a value in a lookup table and saves this value. I have several other queries that run with the final opening a table. This table needs to match the original value that is in the lookup table.

For example, user opens the form and in the dropdown, they select "NAME 1". NAME 1 is then saved to a table.
Then the user would run queries (macro assigned to a button on the form).
Final step in macro opens a table. I need this table name to be NAME 1

The next user may log in and select NAME 243 from the dropdown... same process, final table opening should be named NAME 243.

Any assistance would be appreciated!

 

[ranman256]

Creating new tables like This does not sound like a good method.
why do you need to do this?
normally there is a set number of tables and you move data in and out of them.