Microsoft KB Archive/295265

= ACC2002: Combo Box Wizard Unexpectedly Reports No Valid Fields =

Article ID: 295265

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295265



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
If you select all fields from a table or query in the Combo Box wizard, click Back, and then click Next, you receive the following error message:

No valid fields can be found in ' '. Please select a new source.



CAUSE
This behavior occurs because the Combo Box wizard detects only the currently available fields, not the selected fields. If all fields have already been selected, and no more are available in the Available Fields column of the Combo Box wizard, Microsoft Access generates the error message described in the &quot;Symptoms&quot; section of this article.



RESOLUTION
To work around this issue, change the selected table or query to a different object, click Next, click Back, and then reselect your original table or query.

If your database contains only one table, click Cancel in the Combo Box wizard, delete the combo box control on your form, and then use the wizard to create a new combo box.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Problem

 * 1) Start Access, and then open the sample database Northwind.mdb.
 * 2) Create a new blank form in Design view.
 * 3) Make sure that the Control Wizard is enabled, and then place a combo box on the form.

This also starts the Combo Box wizard.
 * 1) On the first screen of the Combo Box wizard, click Next.
 * 2) On the second screen of the wizard, select the Categories table, and then click Next.
 * 3) On the third screen of the wizard, select all the fields.
 * 4) Click Back to return to the second screen of the wizard.
 * 5) Click Next to move to the third screen of the wizard. You receive the error message described in the &quot;Symptoms&quot; section of this article.

