hi Yes.....that is what exactly i want to achieve but i can't achieve 2 things:-
1. after i changed the comboBox value, the subform didn't refresh that selection on the fly.
2. not sure how to display the last couple records in the subform if not using VBA? (such as Recordset.MoveLast ?? etc.)
I have set both the main & sub Form's Source property point to the same Table ("sql_EFFTEMP-trim" which generated from a query on another Table "EFFTEMP-trim") and also set (at the subform property) both the main & sub-form's link property to the same comboBox's field ("BADGE_no").
In my main form, got same fields which present in the subform for data keyin, and some command buttons to do update table (EFFTEMP-trim) action etc.
I also try using VBA only (without set the above property) , and have sourced some related VBA coding as below but also can't achieve what i want.?!
Private Sub Combo_id_AfterUpdate()
Dim FiltVal As String
FiltVal = Trim(Me.Combo_ID.Value)
Me.[sql_EFFTEMP-trim_Sub_form].Form.Filter = "BADGE_NO='" & FiltVal & "'"
Me.[sql_EFFTEMP-trim_Sub_form].Form.FilterOn = True
End Sub
Any further adv. appreciated !!! Tks a lot.
BR/
beginner