Synchronizing two subforms in MS Access
Posted on 2007-10-10
I have two subforms that I am trying to synchronize and it's not happening. I am wondering if you could help please.
Subform 1 is called frmCampaignsSub (continuous form)
Subform 2 is called frmCampaignsDetSub (single form)
The PK field CP_ID is common to both record sources
When a user clicks or selects a record in Subform 1, I want Subform 2 to show the details accordingly.
Here are my link settings in Subform2 as they related to Subform 1:
Link Child Fields = cp_id
Link Master Fields = Forms!frmMain!frmCampaignsSub.Form!cp_id
So far, Subform 2 is synchronizing ONLY with the first record/row of Subform 1. However, if I move from record to record on Subform 1, Subform 2 is not synchronizing.
Any clues? I would appreciate you nailing any coding syntax using the field and key values I provide in my text.