Hello, i would appreciate help on my problem
Having 2 subforms linked child/parent i am facing problem to have my athletes in second subform chosen by their gender selected in first subform
ist subform is bound to Tbl_Races, second to Tbl_Times
subforms are linked with textbox on main form txtRace(=[Frmsub_Race].[Form]![raceID] / to 2nd Subform raceID
Trying to accomplish on selected gender in first subform then in second subform and in athletesID to show for input only men or women (see pict 3 with selected male race, both men and women are shown for input )
Have tried a bunch of techniques but no joy..
Having 2 subforms linked child/parent i am facing problem to have my athletes in second subform chosen by their gender selected in first subform
ist subform is bound to Tbl_Races, second to Tbl_Times
subforms are linked with textbox on main form txtRace(=[Frmsub_Race].[Form]![raceID] / to 2nd Subform raceID
Trying to accomplish on selected gender in first subform then in second subform and in athletesID to show for input only men or women (see pict 3 with selected male race, both men and women are shown for input )
Have tried a bunch of techniques but no joy..