thank you.
i was attempting to use VBA behind a command button as follows:
SQL = "Insert Into newtable (column1, column2,...) Select * From originaltable"
DoCmd.RunSQL SQL
the problem is specifying all of the columns in destination table. it seems that the following syntax is not...