Does anyone know how to take contents from a form-control and use it in a
make table query as the new table name? thanks >MH
Well... this can be done, using some VBA code to construct the SQL of
the maketable query.
HOWEVER - it's *very rare indeed* to need to make multiple tables, and
a very bad idea in general to prompt the user to provide random,
uncontrolled tablenames.
What is the purpose of these new tables? What will be done with them
which cannot be done with a select query? The latter will let you
generate a Report, a Form, an export, pretty much anything that you
can do with a Table.