filter linked subform using combo box

[siamandm]

thank you, Hans, what i meant is when I type a change the date its not requiring the subform !! how i do requiring after changing the date

i tried these in on chane event of the date from and date to text box :

Code: Select all

Private Sub txtDateFrom_Change()
Call FilterSubForm
End Sub

and

Code: Select all

Private Sub txtDateFrom_Change()
me.subfrm.requery
End Sub

[HansV]

Use the After Update event of the text box:

Code: Select all

Private Sub txtDateFrom_AfterUpdate()
    Call FilterSubForm
End Sub

[siamandm]

Thank you Hans