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

View products that this article applies to.

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).

↑ Back to the top

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.

↑ Back to the top

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]

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

More information

Steps to Reproduce Behavior

1.	Open the sample database Northwind.mdb.
2.	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;
3.	Open the form in Form view and verify that the combo box works correctly.
4.	On Tools menu, click Database Utilities, and then click Upsizing Wizard.
5.	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.
6.	After the Upsizing Wizard is finished, examine and close the Upsizing Report. Note that the newly created Access project opens automatically.
7.	Open the MyForm form in Form view, and try to show the list of values that should appear in the combo box.

↑ Back to the top

References

For more information about the Upsizing Wizard, click Microsoft Access Help on the Help menu, type upsizing wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top