is this a valid SQL statement ? (simple)

[markjkubicki]

I want to copy a record from a table that has lots of fields to a table with the exact same structure (but am trying not to have to list every one of the fields values...)

Is this a valid statement (below)? (It's giving me problems executing and I wonder if I'm trying to do something in a way that simply cannot be done)

(note the suffix of the 2 tables is different: tbe and tbl)

sSQL = "INSERT INTO tbeFixtureSchedulePrintOptions" _
& "SELECT * '" _


& "from tblFixtureSchedulePrintOptions " _
& "WHERE [PresetOption] = " & Me.cboPresetOption
DoCmd.SetWarnings False
DoCmd.RunSQL sSQL
DoCmd.SetWarnings True

many thanks in advance,
mark

[pbaldy]

I always specify the fields, but right off it looks like you won't have a space between the table name and SELECT. If it still doesn't work, add this after the string is built:

Debug.Print sSQL

which will print out the finished SQL to the VBA Immediate window. You can copy/paste it into a new query and try to run it. You'll typically get a more descriptive error.