ACC2002: Combo Box Wizard Unexpectedly Reports No Valid Fields (295265)


The information in this article applies to:

  • Microsoft Access 2002
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 'ObjectName'. 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 "Symptoms" 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.

MORE INFORMATION

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.
  4. On the first screen of the Combo Box wizard, click Next.
  5. On the second screen of the wizard, select the Categories table, and then click Next.
  6. On the third screen of the wizard, select all the fields.
  7. Click Back to return to the second screen of the wizard.
  8. Click Next to move to the third screen of the wizard. You receive the error message described in the "Symptoms" section of this article.

REFERENCES

For more information about combo boxes, click Microsoft Access Help on the Help menu, type combo box in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kberrmsg kbnofix KB295265
©2003 Microsoft Corporation. All rights reserved.