Microsoft KB Archive/229755

= ACC2000: Combo Box or List Box Empty After You Use Upsizing Tools =

Article ID: 229755

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q229755





Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
After you use the Microsoft Access Upsizing Tools to migrate your database to a Microsoft Access client/server application, combo boxes and list boxes that previously functioned correctly now are blank or return the following error message when you use them:

The recordsource 'ut_qry##' specified on this form or report does not exist.



CAUSE
The Rowsource property of the combo box or list box contains one of the following values:
 * A query that uses parameters
 * A query or SELECT statement that references a control on a form in its WHERE clause
 * A SELECT statement that does not specify each output column by using the format [TableName].[FieldName]



RESOLUTION
In your Microsoft Access project, create a stored procedure that returns the data that you want to display in your data-bound control. Then, use the stored procedure in the RowSource property of the control that does not work correctly.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Access 2002.



MORE INFORMATION
Steps to Reproduce Behavior

 Open the sample database Northwind.mdb.  Create the following form:   Form: MyForm --  Caption: Upsizing Test RecordSource: None

Combo box --  Name: Field1 RowSource: SELECT [Categories].[CategoryID],[Categories].[CategoryName] FROM Categories ORDER BY [CategoryName] DESC;  Open the form in Form view and verify that the combo box works correctly. On Tools menu, click Database Utilities, and then click Upsizing Wizard.</li> Upsize all tables in the database to SQL Server or MSDE, making sure to select Create a new client-server application in the What application changes do you want to make option group.</li> After the Upsizing Wizard is finished, examine and close the Upsizing Report. Note that the newly created Access project opens automatically.</li> Open the MyForm form in Form view, and try to show the list of values that should appear in the combo box.</li></ol>

<div class="references_section">