Susan Harkins
ssharkins at bellsouth.net
Tue Sep 16 11:15:38 CDT 2003
That error usually means there's a typo in the statement -- a missing space maybe? I get that one a lot myself when building a statement via variables and something will return together like ... WHERECompanyName... something like that. Susan H. > Hi Gustav, > I tried that and it returns an error message "Error 3061 Too few parameters > Expected 3". The underlying query does rely on a subquery which does have 3 > parameters but the parameters are supplied by an open form and runs just > fine until I reference it it code. Any thoughts on why and how to fix? > Tim