Access specific row of subform
I have a form that has two subforms within it. Basically, I want to access data from a specific row(the row will have a Main field set to "Yes")in the first subform to use as data in the second form. So what I'm having trouble with is accessing the specific row that has main set to yes.