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

ID: Q225915

The information in this article applies to:
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 <object> 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.


MORE INFORMATION

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          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: July 12, 1999