ACC2002: Source Object of a Subform Is Set to a Table Name Instead of to a Form Name in an Access Project (295236)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295236
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you select to insert a subform into a form in an Access project (.adp), and the subform has the same name as a table, the Subform Wizard inserts the table rather than the form. When you look at the SourceObject property of the subform, you see that it is set to Table.<TableName> instead of to the name of the form.

RESOLUTION

Manually change the SourceObject property to Form.<FormName>. To do so, follow these steps:
  1. Open the form in Design view.
  2. Right-click the subform, and click Properties on the shortcut menu.
  3. On the Data tab of the property sheet, set the SourceObject property as follows:
        Form.<FormName>

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. In an Access project, create any table and name it Table1.
  2. Using one of the AutoForms, create a form that is based on Table1, and then save it as Table1.
  3. Create a new form that is not based on any table or query, and then name it Form1.
  4. Open the Form1 form in Design view.
  5. In the toolbox, ensure that the Control Wizards button is pressed in, and then add a subform to your form. This starts the Subform Wizard.
  6. On the first page of the Subform Wizard, click Use an existing form, click the Table1 form, and then click Finish.
  7. Note that the Wizard inserted the table named Table.Table1 instead of the form.
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbbug kbnofix KB295236
©2003 Microsoft Corporation. All rights reserved.