linking two subforms

  • Thread starter Thread starter Derek Grasby
  • Start date Start date
D

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
 
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.
 
Back
Top