ACC2002: Upsizing Wizard Fails to Upsize Form References in WHERE Clause (287487)
The information in this article applies to:
This article was previously published under Q287487 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS
To limit the number of records returned in a form, a combo box, or a list box, it is common practice to use a form reference. However, during the upsizing process, the Upsizing Wizard removes the form reference, leaving an incomplete SQL statement. When you run the incomplete SQL statement, you receive the following error message:
Invalid SQL Statement. Check the server filter on the form record source
CAUSE
The wizard fails to upsize the form reference in a combo box, a list box, or a form's record source. As a result, the SQL statement is incomplete. It is important to note that, when a query is upsized, the form reference is changed to a named parameter.
RESOLUTION
After the upsizing is finished, modify the SQL statement to include the correct named parameter instead of a form reference.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCES
For additional information about implementing query by form in Access projects, click the following article number to view the article in the Microsoft Knowledge Base:
286828
How to implement Query By Form (QBF) in an Access project
For additional information about parameterized combo boxes in Access projects, click the article number below
to view the article in the Microsoft Knowledge Base:
281870 ACC2002: How to Use Parameterized Combo Boxes in an Access Project
For more information about named parameters and how to create them,
refer to SQL Server Books Online at the following Microsoft Web site:
Modification Type: | Minor | Last Reviewed: | 6/7/2004 |
---|
Keywords: | kbbug kberrmsg KB287487 |
---|
|