accessing a query from a sql string 1

[elpico]

I've got this piece of sql

SELECT [My Query].* INTO ConfigFileAllSites
FROM [My Query];

that runs this query

SELECT [site].[sitename], configfile.*, [site].[envid]
FROM site, configfile
ORDER BY [site].[sitename], [ConfigFile].[Module], [ConfigFile].[ConfigFileName];

- which runs fine from the standard Access query window - However, I want to run it from within a VB function linked to my form, but its not recognizing my query within the string - any idea if this is possible to do, and if so how?

Thanks,
e.

 

[lupins46]

dim strsql
strsql = "SELECT [My Query].* INTO ConfigFileAllSites
FROM [My Query]"
currentdb.execute strsql,dbfailonerror