strSQL Question -- quick

[jeninOk]

strSQL:

(([Sq_Ft] = 36317) AND ([County] In ('Canadian'))

Does anyone see what the problem is with this when used in:

DoCmd.OpenForm FormName:=strForm, View:=acNormal, WhereCondition:=strSQL

 

[Dirk Goldgar]

strSQL:

(([Sq_Ft] = 36317) AND ([County] In ('Canadian'))

Does anyone see what the problem is with this when used in:

DoCmd.OpenForm FormName:=strForm, View:=acNormal, WhereCondition:=strSQL

I see four left parentheses and only three right parentheses.

 

[jeninOk]

Thanks!!!!!!!!!!!!!!!!!!!!

strSQL:

(([Sq_Ft] = 36317) AND ([County] In ('Canadian'))

Does anyone see what the problem is with this when used in:

DoCmd.OpenForm FormName:=strForm, View:=acNormal, WhereCondition:=strSQL

I see four left parentheses and only three right parentheses.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)