Change a subform's recordsource from another subform in Access
- by Dkellygb
I am using MS Access 2003 and I have a form with two subforms (subform1 and subform2) which are not nested. They both display tabular data on them so they cannot be nested. I would like to change the recordsource on subform2 based on a value in the current record on subform1.
I have tried to put the code in the oncurrent event of subform1 but I…