Filtering subform

[marlon]

HOw do i filter a subform using code ?
I've a checkbox on the main form when i enable it i want to filter the subform.

thanks for your assistance in advance

 

[Allen Browne]

Set the Filter and FilterOn properties of the form in the subform control.

Example:

With Me.[NameOfYourSubformControlHere].Form
.Filter = "Surname = """Smith"""
.FilterOn = True
End With