Microsoft KB Archive/295263

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

Article ID: 295263

Article Last Modified on 10/20/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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 &quot;Release Manifest for MDAC 2.6 RTM (2.60.6526.3)&quot; 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.



Steps to Reproduce the Behavior
 Create a new Microsoft Access project by clicking Project(Existing Data) in the task pane. In the Data Link Properties dialog box, select or enter your Microsoft SQL Server name. Select the NorthwindCS database. In the new Microsoft Access project, create a new form in Design view. Do not base the form on a table or query. On the View menu, click Properties.</li> In the property sheet for the form, click the Data tab.</li> Set the RecordSource property of the form as follows:

SELECT * FROM Customers

</li> Close the property sheet.</li> View the field list. It may be blank.</li></ol>

Additional query words: pra Field List fieldlist

Keywords: kbbug kbfix kbclientserver KB295263

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.