Solved Referencing a combobox in 2nd Subform, Vba Runtime error 2455 Invalid reference to the propery form / report (1 Viewer)

[Manos39]

Here is what I have. It is much simplified and works. All subforms are continuous.

Just tested it. It does not TRY your self. See having selected a race in 1st subform which is for women, choce i have when i need to record womens times only in my related sub form, is for BOTH men and WOMEN

 

[Manos39]

Larry i need you to understand me this is what i need but in continues mode subforms

 

[LarryE]

Then open the subforms in design mode and change the Default View to Continuous from Data Sheet. I am so sorry I could not help you. Maybe some else can help you further. Since I cannot read your language, I could not tell from the data which is Men and which is Women. I have done all I can.

In this final file, I did include a GenderID filter in the Ahtletes / Times form, so it should filter based on gender record selected in the Races form. It's the best I could do.

 

[Manos39]

You ve been great and it meant a lot to see your concern to help Larry

 

[Manos39]

These are the true conditions for selecting either male or female athlete swimmers when referring from Tbl_Times (athleteID)
to Tbl_Races (depending on Gender) between record sets

 DLookUp("agenderID";"Tbl_Athletes";"athleteID=" & Nz(DLookUp("genderID";"Tbl_Races";"raceID=" & Nz(([Forms]![Fr_Gala]![Frmsub_Race].[Form]![raceID]);0));0))

.. but no idea comes on how put it in the rowsource of athleteID in Frsub_Time..

new try picture is indicating in 1st sub a stroke of men's 100m and in 2nd sub one could choose men AND women athletes

 

[LarryE]

1. Open the athleteID Row Source on the form
2. Add the agenderID field from the tbl_Athletes table
3. Put [Forms]![Fr_Gala]![Frmsub_Race]![genderID] in the Criteria box in the agenderID field

 

[Manos39]

1. Open the athleteID Row Source on the form
2. Add the agenderID field from the tbl_Athletes table
3. Put [Forms]![Fr_Gala]![Frmsub_Race]![genderID] in the Criteria box in the agenderID field

I have tried that Larry, test it does not work.. wait if in 1st sub and in the after update event of genderID is put to requery athletesID in second sub form, with Me.Parent.Frmsub_Time.Form.athleteID.Requery , then it works... but i t has some issues though.. If athletes and times are typed athletes are getting lost when close and reopen main form