[AccessD] Link child / master field fails in subsubform

It turns out it had to do with the name of the field it was bound to.  The
field name was the same in the child and the parent and I guess the wizard
just got them wrong somehow.  I went in and aliased the IDs in the queries
for the main form and the child form, reran the query that builds the links,
and the problem went away.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Monday, November 24, 2003 5:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Link child / master field fails in subsubform


Hi John

Could it be that you are fiddling with the AllowEdit etc. properties
of the sub(sub)forms?
If so, you may need to reassign the LinkMaster/ChildFields settings
(to themselves) when opening the mainform.

/gustav


> Date: 2003-11-22 19:57

> I have a db where the subform pulls the correct records using ling child /
> master field properties, but the subsub form fails to follow the subform,
> i.e. it pulls a set associated with the parent form but not associated
with
> the first subform.

> Agency / contract / assignment.  As I move through agency records I see
the
> contract change.  I also see the assignment change, but as I move through
> the contracts the assignments don't change.

> I have seen this before, and worked around it by just replacing the link
> properties with query filters in the subform.

> Has anyone seen a bug fix for this?

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com