linking two subforms

J

Jeremy1048

Bit of a problem that keeps cropping up with my databases.

I'm trying to display the same record data on a form in two subforms and
keep them synchronised. Basically replicating the calls form of the contact
management database of access 97

At the moment I have a hidden link field (linkevent below)pointing to the PK
of the summary subform and that is listed in the masterfield of the data
properties of notes subform. The pk of the table is listed as the childfield.

e.g.

child: employeeid; eventid
master: employeeid, linkevent

What's getting me annoyed is that one time it works and one time it doesn't
and there's nothing i do differently. Is there anyway to make this a little
more stable when creating these. Or am i missing something horrendously
obvious as i'm prone to do.
 
Top