Search results

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

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

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

There is no need to redesign my Database. It is working with the relationships. (in your excample TbL_Times alone should hold info of the event (mean Distance - Stroke) otherwise athlete has a time but in which combination event) ? Please take a look my latest attachment. Can say it is working...

In first picture is my sample Database relationships uploaded here. .(i uploaded a sample database and part of my real db). It should work fine. Think of the logic of it.. problematic i think might be as for naming tables like that. Maybe because i am doing this to help a friend and i dont have...

hi Round No means it is eg 9th Olympic or 1st of Grammy Awards

Thanks for helping it does not work...I have upload another Db, in which Fr_Galas is working as it should, however i need the two subforms to work in continues mode not datashhet mode, (which i did not managed doing) also in same database, Frmsub_races as a main form for testing is working ok...

Maybe if typed something like Forms!Fr_Gala!Frmsub_Times.Form!athleteID.RowSource = "SELECT athleteID FROM Tbl_Athletes WHERE (((Tbl_Athletes.agenderID)= " & Nz(Me.genderID, 0) in the on current event of 1st subform but i cant do that without errors

It might have not been uploaded in the corrected version, as far as i tested, still when gender in first sub is selected eg as for women, second subform' s athleteID is not populated by women athletes or the opposite

Thank you i shall see those and learn by that

I suppose it is getting quite strange i ve done as advised but no luck . .. Only when change one time in 1st sub (Frmsub_Races) genderID, then 2nd s subform (Frmsub_Times) cboAthlete selects ok Not automatically as intended i dont know what am i doing wrong.

Thanks for helping me i suppose you have solved my issue. I ll confirm in the morning.. Great!!

Hello, i am stuck to a problem which is annoying Have a main form, Fr_Gala (single form) with two continues subforms (Frmsub_Races), and (Frmsub_Times) I need this to work like .. having swimming races in 1st subform, then in second subform which is linked as child to 1st, one could type...

Thank you for responses and advice Crystal. I thought i wrote what problem was specifically -- need to populate combobox athletesID (in second subform " Frmsub_Times"), depending on first subform's "Frmsub_Races" selected genderID, to show men or women not both)-- Anyway i am far from able...

Thank you for advice Crystal, tried the db but still athleteid in 2nd subform keeps populating for selection male and female although 1sr and 2nd subforms have now LinkMasterField and LinkChildFields.. Below i attached the db_differences just to witness how Fr_Galas (with 2 subforms in...

Thank you for the advice i shall try that way and respond hopefully layer on. Ι also have to say that i have managed to accomplish what i needed but the subforms which worked was i datasheet view only which was not practical and nice. Then i tried my subforms set to continuous and Same...

Hello, i tried to associate value of a combo box between two subforms which are linked in my form Fr_Events Problem i guess is that desired combobox which is in second subform has no rowsource related to first combobox Specifically i need to populate combobox athletesID (in second subform...

quote marks was a way to show it like instead press CODE

This is my db and form is Fr_ScheduleEditor I keep trying things so it has some changes still no luck though

I am sorry it is recordsourse