Microsoft KB Archive/295236

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

Article ID: 295236

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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. instead of to the name of the form.



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

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

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.

Additional query words: pra subform project wizard SourceObject

Keywords: kbbug kbnofix KB295236

-

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

© Microsoft Corporation. All rights reserved.