access vba createqry error 13 mismatch

[RCBricker]

I am just not seeing this error.

my code is:

                Set qdf = dbF.CreateQueryDef(strQRYN, strSQLQRY)
                Application.RefreshDatabaseWindow

my two variable strings are:

strSQLQRY=
SELECT * FROM [tbl_ERP_JSTO_DAI_CBPD_DAI_TB 2015] WHERE (([tbl_ERP_JSTO_DAI_CBPD_DAI_TB 2015].[DB FYMonth] = '1'));

strQRYN=
qry 2015 October DAI GL to TB Data Validation

any ideas why this is not working?

 

[RCBricker]

if I wrap the create query in a resume next error handling. the code continues and the query is created. I am confused!

 

[xenou]

It works for me. The mismatch might be a problem in the actual sql query you created (for instance, the month data might be numeric, not string data).