I'm on the form called frmMembership. Based on selecting a parent name, only their kids would appear in the gymnast combo box. The code that I have does just that so it gives me just what I want. What I can't understand is how this worked.
Code:
Private Sub parent_AfterUpdate()
Me.gymnast.Requery
End Sub
This form is based on the table 'Membership.' I know both values appear in membership now, but the filtered values in the gymnast combo box still appeared even before the first row of data was entered.