SELECT INTO variable from Form

[prezlincoln]

Hi, I have a Make table query that uses the stored values from a form to make a new table. I've added a text box on the form for the new table name; however, I've been unable to modify the INTO variable to retreive the form's stored value.

How do I direct SELECT * INTO to [Forms]![frmMakeNewTable]![tboNewName]?

Thanks!

 

[Norie]

You can't use values from a form for something like a table name like you can with the criteria.

As far as I know you would need code to do this.

Mind you, how many tables are you actually going to create?

Is this just a quick method to let you create a one-off table?

Or are you going to create multiple tables and populate them from another table/tables?

 

[prezlincoln]

Thanks, Norie.

This form will be used by over and over to create cusomized tables for a separate geodatabase. I've done it with a set name in the sql, but I would like users to specify the desired name in the form.

How could I do it with a code?