Stuart McLachlan
stuart at lexacorp.com.pg
Mon Dec 4 18:46:19 CST 2006
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 :-(