Microsoft Access 2007 reports  on Vista: syntax error in Parameter clause.

I was getting an "error executing command" from the switchboard in Access 2007 on Vista. The app was Access 2002-2003 based, but after converting it to 2007 it still happens.

When I run the report itself I get "Syntax Error  in Parameter Clause"

When I open in design mode and run the query, it runs fine. When I run the report I get the error.

It runs fine in Access 2003 and 2007 on XP machines. (And then people are surprised I don't like Vista... )

The data are actually on MS SQL 2000 and accessed via ODBC, this config has worked fine for years. Most of the app works fine except for reports with parameters

Here is the query:

PARAMETERS [Which Class] Text ( 255 );
SELECT vwCollectedBalance.Collected, vwCollectedBalance.Tuition, vwCollectedBalance.BalanceDue, vwCollectedBalance.ClassNo, PaymentStatus.PaymentStatus, EnrollmentType.EnrollmentDescription, PaymentStatus.PaymentStatusSortOrder, EnrollmentType.EnrollmentReportOrder, [LastName] & ", " & [Firstname] AS Name, FundBusterStatus.FundBusterStatus, vwCollectedBalance.ContactID
FROM (((vwCollectedBalance INNER JOIN EnrollmentType ON vwCollectedBalance.EnrollmentID = EnrollmentType.EnrollmentID) INNER JOIN PaymentStatus ON vwCollectedBalance.PaymentStatusID = PaymentStatus.PaymentStatusID) INNER JOIN Contacts ON vwCollectedBalance.ContactID = Contacts.ContactID) INNER JOIN FundBusterStatus ON Contacts.FundBusterStatusID = FundBusterStatus.FundBusterStatusID
WHERE (((vwCollectedBalance.ClassNo)=[Which Class]));

So what gives?

Thanks for your help!

Rolf
Start Free Trial