Microsoft KB Archive/225915

= ACC2000: Stored Procedures Do Not Appear as Record Source in Forms, Reports, or Pages =

Article ID: 225915

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225915



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

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



SYMPTOMS
When you create a new form, report or data access page, the New Form, New Report and New Data Access Page dialog boxes do not list any of your Stored Procedures in the list of available data sources for the object. When you create these objects using a wizard, stored procedures are also not listed in the Tables/Views list within the wizard.



CAUSE
The functionality for displaying stored procedures as potential record sources in the New  dialog box and in the wizards for forms, reports, and data access pages was not included in Microsoft Access 2000.



RESOLUTION
In Design view of the object, select a stored procedure as a record source. To do so, use one of the following methods.

For Forms or Reports
In Design view, on the View menu, click Properties. Click the Data tab, and type the stored procedure name in the RecordSource property box.

For example:
 * 1) Open the sample Access project, NorthwindCS.adp.
 * 2) In the Database window, click Forms under Objects.
 * 3) Click the New button on the Database window toolbar.
 * 4) In the New Form dialog box, click Design View and click OK.
 * 5) On the View menu, click Properties. Click the Data tab, type Employee Sales by Country, and press ENTER.

Note that the field list appears with the appropriate fields from the Employee Sales by Country stored procedure.

For Data Access Pages
In Design view, if the field list is not visible, click Field List on the View menu. Click the plus sign (+) next to Stored Procedures. Click the stored procedure to use for this page.



Steps to Reproduce Behavior

 * 1) Open the sample Access project, NorthwindCS.adp.
 * 2) In the Database window, click Forms under Objects.
 * 3) Click the New button on the Database window toolbar.
 * 4) In the New Form dialog box, click the wizard that you want to use. A description of the wizard appears on the left side of the dialog box.
 * 5) Look for a record source named Employee Sales by Country. Note that this record source does not appear in the list.

Additional query words: pra prb record source wizard stored procedure proc

Keywords: kbprb kbclientserver KB225915

-

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

© Microsoft Corporation. All rights reserved.