I have a main form that is unbound. Within that main form I have 4 subforms, 2 that are continuous forms (ContMain and Cont2) and 2 that are pivotcharts (PC1 and PC2). Subform ContMain has a list of items that when one row is selected, the other three subforms should update.
I have Cont2 updating based on two text boxes on the main form that have their control source linked to the appropriate fields on ContMain. When a new row is selected in ContMain, the two text boxes on the main form change to reflect the linked fields. Cont2 has its Link Master and Link Child fields linked to the text boxes on the main form.
Is this the best way to handle this or would it be better to use VBA and have the other subforms update using the OnCurrent event of ContMain?