Search results

Me.Parent.subfrm2.form.recordsource = "SELECT ...." will not work. there is frmMain, and subfrm1 and subfrm2 are placed on frmMain. the point is: as i change record on frmMain (OnCurrent event), subfrm1 must show related records on frmMain, and when i select or change record on subfrm1...

subfrm1 & 2 are independent subforms on frmMain as u could see in my post, i tried your way but it didn't work... as i change record on subfrm1, the recordsource of subfrm2 should change according to change of id in selected record on subfrm1, that's why i need this

hi i have frmMain which contains subfrm1 and subfrm2. i'd like to change recordsource of subfrm2 from subform1's event. i tried several ways to do it but i didn't succeed. if i try to do it from some frmMain event, there is no problem (me.subfrm2.form.RecordSource = "SELECT ..." and it's...