Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 207662 - Last Review: June 28, 2004 - Revision: 2.0
ACC2000: Parameter Prompt If LinkMasterFields or LinkChildFields Contains Table Name
This article was previously published under Q207662
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
Moderate: Requires basic macro, coding, and interoperability skills.
When you open a form that contains a subform or a report that contains a
subreport, you may receive an unexpected prompt to enter a parameter value.
The
LinkMasterFields or
LinkChildFields property of the subform or subreport contains a reference to the underlying table or query. This table or query could be the record source of the main form, the main report, the subform, or the subreport. The property's value is in the format
MainTable.FieldName
Because the reference to the table or query underlying the form or report
is implied, it is not necessary to include the table or query name in the
LinkMasterFields or
LinkChildFields property.
Use one of the following resolutions to correct the behavior of the form or
report:
- Do not refer to the underlying table or query in the LinkMasterFields or LinkChildFields property.
-or-
- Refer to a control name on the main form or report that contains the
appropriate value for the link criteria.
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- In the Database window, click Forms under Objects, and then click New.
- In the New Form dialog box, click Form Wizard, and then click OK.
- On the first screen of the Form Wizard, click Table: Categories in the Table/Queries list.
- Move the CategoryID, CategoryName, and Description fields from the
Available Fields list to the Selected Fields list.
- Click Table: Products in the Table/Queries list.
- Move the ProductID, ProductName, CategoryID, and UnitPrice fields from the Available Fields list to the Selected Fields list, and then click Next.
- On the screen that asks you how you want to view your data, click By Categories, and then click to select Form with subform(s). Click Next.
- When asked what layout you would like for your subform, click to select Datasheet, and then click Next.
- When asked what style you would like, click Standard, and then click Next.
- When asked what titles you want for your forms, type frmLinkMain in the Forms box and frmLinkSub in the Subform box. Then click Finish.
- On the View menu, click Design View.
- Right-click frmLinkSub, and then click Properties.
- Change the LinkChildFields property to Products.CategoryID, and change the LinkMasterFields property to Categories.CategoryID.
- View the form in Form view.
Note that you are prompted for the parameters Categories.CategoryID and Products.CategoryID.
For more information about linking main forms and subforms or main reports and subreports, click
Microsoft Access Help on the
Help menu, type
LinkChildFields, LinkMasterFields Properties in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
APPLIES TO
- Microsoft Access 2000 Standard Edition
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