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

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.

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.
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.
After the Upsizing Wizard is finished, examine and close the Upsizing Report. Note that the newly created Access project opens automatically.
Open the MyForm form in Form view, and try to show the list of values that should appear in the combo box.

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.