ACC2002: Field List May Be Blank If RecordSource Property of a Form in an Access Project Is Set to an SQL Select Statement (295263)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295263
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

The field list of a form in an Access project may be blank if the RecordSource property of the form is set to a SQL Select statement.

CAUSE

This problem occurs if both of the following conditions are true:
  • The form has a SQL Select statement as its record source.

    -and-
  • You are running Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows Millennium Edition.

RESOLUTION

To work around this problem, use either of the following methods.

Method 1

Select a table or a query as the record source of the form.

Method 2

Download and install Microsoft Data Access Components (MDAC) 2.6.

IMPORTANT: Before you download MDAC 2.6, please read the "Release Manifest for MDAC 2.6 RTM (2.60.6526.3)" page at the following Microsoft Web site:

http://www.microsoft.com/data/mdac26info/Manifest26RTM.htm

To download MDAC 2.6, visit the following Microsoft Web site:

http://msdn.microsoft.com/dataaccess

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 Behavior

  1. Create a new Microsoft Access project by clicking Project(Existing Data) in the task pane.
  2. In the Data Link Properties dialog box, select or enter your Microsoft SQL Server name.
  3. Select the NorthwindCS database.
  4. In the new Microsoft Access project, create a new form in Design view. Do not base the form on a table or query.
  5. On the View menu, click Properties.
  6. In the property sheet for the form, click the Data tab.
  7. Set the RecordSource property of the form as follows:

    SELECT * FROM Customers

  8. Close the property sheet.
  9. View the field list. It may be blank.
Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kbbug KbClientServer kbfix KB295263
©2003 Microsoft Corporation. All rights reserved.