Solved Filter cascading comboboxes between subforms (1 Viewer)

[Manos39]

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..

 

[arnelgp]

i made qryTimes (which include genderID) and use it as Recordsource of subform frmsub_Time.
i also add code to the subform frmSub_Race's Current event to change the recordsource fo frmSub_Time
to only Gender on the frmSub_Race.
i added code to the GotFocus event of athleteID combobox of frmSub_Time to only show Athletes with
same gender as in frmSub_Race.

 

[Manos39]

i made qryTimes (which include genderID) and use it as Recordsource of subform frmsub_Time.
i also add code to the subform frmSub_Race's Current event to change the recordsource fo frmSub_Time
to only Gender on the frmSub_Race.
i added code to the GotFocus event of athleteID combobox of frmSub_Time to only show Athletes with
same gender as in frmSub_Race.

I appreciate help but something happens when inserted, records dont reappear next time db opens..

 

[arnelgp]

dont reappear next time db opens.

where are you adding record to the Time subform?
the name are not coming out because your last record has male and female mixed
on the same time subform.

 

[Manos39]

where are you adding record to the Time subform?
the name are not coming out because your last record has male and female mixed
on the same time subform.

I shall erase records and try again and i let you know

 

[Manos39]

I have had erased records both in tbl_times and Tbl_Races and when using correted (your form with subforms), same problem in fact there is a problem with coding in afterupdate of Frmsub_Race (attached pictures), and again when close and reopen Main form, records made using Frmsub_Time dont reappear in second subform (frmsub_Time)
See attached db, in different raceID with records applied, records for females typed, dont reappear when reopen

 

[arnelgp]

you Delete the AfterUpdate and AfterInsert from your code.
that was Originally there (you added that?), i only added Current event to your frmSub_Race.

 

[Manos39]

Please try yourself in your example. It s been weeks since i try accomplish what i want. In your attachment with no deletions
do you see not that when reopen db does not hold records? It making me crazy. This is your upload reopened and untouched..

 

[arnelgp]

try this modification.

 

[Manos39]

try this modification.

its GREAT!!! what have you Done??

 

[arnelgp]

see the Gotfocus and Lostfocus event of the the athleteID of Frmsub_Time.