Thank you everybody.
I just tested the first solution by Cronk and it works perfectly well with small modifications:
Private Sub FilterCheckBox_Click()
If FilterCheckBox.Value = True Then
Me.RecordSource = "select * from q29_General_Overview inner join q27_KitsWithSharedParts_2 on...
Hi,
First, sorry for my english, I'm french... I do my best I promise!
I have a subform containing details about Kits to mount (for production purposes).
Several of these kits share parts with other and I made a query to identify that.
So we have a subform with my kits and their details:
Kit...