Solved Referencing a combobox in 2nd Subform, Vba Runtime error 2455 Invalid reference to the propery form / report
- Thread starter Manos39
- Start date
LarryE
Well-known member
- Local time
- Today, 11:26
- Joined
- Aug 18, 2021
- Messages
- 1,112
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.
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.
Last edited:
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
.. 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
to Tbl_Races (depending on Gender) between record sets
Code:
DLookUp("agenderID";"Tbl_Athletes";"athleteID=" & Nz(DLookUp("genderID";"Tbl_Races";"raceID=" & Nz(([Forms]![Fr_Gala]![Frmsub_Race].[Form]![raceID]);0));0))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
Attachments
Last edited:
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
Last edited:
