I have a form setup with two subforms, as shown below:
I am trying to set it up to where the subform on the right, Workgroup Updates, changes to different information when cycling through the records on the left. Just by the look, they are tied together by "Application Role Name" (in this case Test-Role-2). However, this information is showing while Test-Role is selected. I'd like Test-Role to show its own information, then have that form change to Test-Role-2 when the 2nd record is selected.
I am trying to set it up to where the subform on the right, Workgroup Updates, changes to different information when cycling through the records on the left. Just by the look, they are tied together by "Application Role Name" (in this case Test-Role-2). However, this information is showing while Test-Role is selected. I'd like Test-Role to show its own information, then have that form change to Test-Role-2 when the 2nd record is selected.