I need a subform to requery so it pulls all of the records associated with multiple selections chosen in a separate subform, rather than a single selection.
In one subform (subformEXIndicators), users identify up to 5 "indicators" associated with a particular video clip using the control EXINIndicator.
In a separate subform (subformEXMarkers), users select the "markers" associated with the video clip using the control EXMAMarker.
Each "indicator" has from 2-5 "markers," so what I'd like to do is have EXMAMArker (or subformEXMarkers) query subformEXIndicators so that the markers for ALL of the indicators entered on subformEXIndicators are listed in its combo box drop-down list.
Currently, I have a requery for EXMAMarker in VBA, but it only allows for the markers associated with the last indicator entered to come up. Here's the code:
Private Sub EXINIndicator_AfterUpdate()
Forms!ExemplarEntry!subformEXMarkers!EXMAMarker.Re query
End Sub
Thanks for any suggestions you can offer! This is my first post, so if there's needed info I've leaving out, please let me know.