View Full Version : Link Child Fields requesting Parm


Paul Wagner
12-30-2004, 12:15 PM
In my report I have an unbound key field in the Page Header whose control source is tblFacultyBudgetHeader.FBH_PK, fed by a form value.

I have added a subform onto the report in a footer group which requires two linked keys, FBH_PK and BudgetCategoryCode. Thus, upon completion of the subform the Linked keys from properties are:

Linked Child Fields: FBH_FK;BudgetCategoryCode
Linked Master Fields: tblFacultyBudgetHeader.FBH_PK;BudgetCategoryCode

The subform works with one small hitch: I get a "Enter Parameter Value" box asking for tblFacultyBudgetHeader. I simply press OK and the report still works.

What is this? What does it think is unresolved?

Thanks

Pat Hartman
12-30-2004, 01:52 PM
Fields should not be qualified by table names. Fix the ControlSource for FBH_PK. If Access puts the table name back, the problem is with the query. Modify the query so that it contains only one instance of the name FBH_PK. If for some reason you want the field to appear more than once in the query, give each occurance an alias so that all field names are unique. You may have to manually fix the master/child links again after you fix the ControlSource and query.