[AccessD] error 3061 too few parameters 2003

Yes - the underlying queries all have some form criteria......not the main query referenced in the code.

I've tested all underlying queries and they work in the query window, so it could be, as you say, that I'm not going to get away with that in Access 2003, even though A2K allowed it.

I'll do that search

Kath
  ----- Original Message ----- 
  From: Stuart McLachlan 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, December 05, 2006 11:46 AM
  Subject: Re: [AccessD] error 3061 too few parameters 2003


  On 5 Dec 2006 at 10:06, Kath Pelletti wrote:

  > Anyone know why this code would give me error 3061 - 'too few parameters' when I run it in Access 2003 (it runs fine in A2K).
  ...
  > strsql = "SELECT * FROM QryHistory_PortfolioMVandIncome"

  Does QryHistory_PortfolioMVandIncome contain any criteria that point to a control on a Form?
  If so, you need to use a work-round such as a static function to pass that parameter to the query rather than a control 
  reference. (Search the archives for "Static function")

  But then, that shouldn't work in A2K either :-(








  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com