strSQL Question -- quick

  • Thread starter Thread starter jeninOk
  • Start date Start date
J

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
 
jeninOk said:
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
Click to expand...


I see four left parentheses and only three right parentheses.
 
Thanks!!!!!!!!!!!!!!!!!!!!
Dirk Goldgar said:
jeninOk said:
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
Click to expand...


I see four left parentheses and only three right parentheses.

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

(please reply to the newsgroup)
Click to expand...
 
Back
Top