Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 207755 - Last Review: July 13, 2004 - Revision: 1.1
ACC2000: Subform Field Linker Builder Error Creating Links
This article was previously published under Q207755
This article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user computers.
When you click the
Subform Field Linker Build button next to the
LinkChildFields or
LinkMasterFields property of a bound subform property sheet, you may receive the following error message:
Can't build a link between unbound forms.
The linking field for the main form is not bound to a table or query.
You must manually create the link between the main form and the subform by
typing the field names that you want to use in the
LinkChildFields and
LinkMasterFields property boxes.
You will be able to use the Subform Field Linker Builder to link the fields in your main form/subform combination only if the following conditions are true:
- Both the main form and the child object are based on tables or queries, and a relationship between those objects has been defined with the Relationships command.
- The main form is based on a table with a primary key, and the subform is based on a table or query that contains a field with the same name and the same or a compatible data type as the primary key.
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- Create a new form not based on any table or query in Design view, and save the form as Form1.
- Add a combo box to the form with the name SelectCustomer.
- Set the RowSource property of the SelectCustomer combo box to:
Select CustomerID from Customers ORDER BY CustomerID
- Close and save Form1.
- Use the AutoForm: Columnar Wizard to create a new form based on the Orders table. Save the form as Form2, and then close it.
- Reopen the Form1 form in Design view and position the form so that you can see the Database window. Drag the Form2 form from the Database window to the detail section of the Form1 form.
- View the properties of the Form2 subform control, click the Data tab, and position the pointer in the LinkMasterFields property box. Click the Build (...) button.
Note that you receive the error message mentioned in the "Symptoms" section.
For more information about creating links between a main form and a subform, click
Microsoft Access Help on the
Help menu, type
How Microsoft Access links main forms and subforms in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kberrmsg kbprb kbusage KB207755 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate