Filter Subform From Another Subform

[JGrots]

I want to filter a subform (TrainingTopics Subform) by its category Field by double-clicking on the Category field in another subform (TrainingQry2 subform).





Here is the code I have but it doesn't work:

Private Sub Category_DblClick(Cancel As Integer)

Forms![Employees Form]![TrainingTopics subform].Form.Filter = "Category = " & Me.Category & ""
Forms![Employees Form]![TrainingTopics subform].Form.FilterOn = True

End Sub

Any help would be greatly appreciated. Thank you!

[RuralGuy]

SubForms have a built-in filtering system with the LinkMaster/ChildFields properties of the SubFormControl. If you create an invisible TextBox with a control source that points to your Category field in the TrainingQry2 subform then you can set the MasterLinkField to point to the invisible Textbox and it will just work.

[JGrots]

Thanks RuralGuy but I can't get the text box to display the Category Name. I have the this: =Forms![TrainingQry2 subform]![Category].OnDblClick for the Control Source in the text box. When I double click on a category name in the TrainingQry2 subform, the text box doesn't display the name; it displays #Name? instead.

[RuralGuy]

Try: =[TrainingQry2 subform].FORM.Category

[JGrots]

Wow that works great. Thank you!

[RuralGuy]

Magical isn't it? Glad we could help.