linking two subforms

[Derek Grasby]

Building a database modelled on the Access 2000 example, Contacts.mdb. I
want to replicate the subforms as shown on the 'calls' tab where a datasheet
style subform lists calls made, and an adjacent subform displays the memo
for each of the calls chosen. I have linked the forms ok, but I cannot get
the memo subform to change when a different call is chosen - it simply
displays the memo for the first call on the list. I have looked hard and can
see no difference between the way I have set it up and the way the
contacts.mdb sample is set up. How can I try to make this work?

Derek Grasby
Bristol UK
(e-mail address removed)9.co.uk

 

[Joan Wild]

Hi Derek,

If think you are missing the code behind the CallListSub subform. Open it
in design
view and then View, Code and you'll see the code that refreshes the
CallNotesSub.

However, I usually don't synchronize subforms like this. You can do away
with the code and instead put a textbox on the main form and set it's
Control Source to =[CallListSub].[Form]![CallID] and set it's Name to
txtLink.

Then set the LinkChild to CallID and LinkMaster to txtLink for the
CallNotesSub control.