Filter main form by clicking on cell in subform?

[ittechguy]

I've got a form which contains an unbound subform in the detail portion. The subform is not linked to the mainform. It displays all information from tblEquipment.

In the header, I have several combo boxes and text boxes used to either add a new record to tblEquipment or to make changes to records in tblEquipment.

In the footer, I have a search form
This search form filters the subform and it also filters the main form. So, I can select say... a specific. Equipment Serial Number and see that record's information in the header combo boxes (these all being bound to a query).

What I would like to do is make it so that if you double click on a cell in the subform, the main form would be filtered. For instance, suppose I click on serial number "12345", I should then see that record in the main form.

...how is this done? I imagine the code needs to go in the subform. If I'm right, I'm not sure how to refer to the main form from the subform.

[ittechguy]

Figured it out!

I just had to add this code to a text box in the subform:

Private Sub SerialNum_DblClick(Cancel As Integer)
Forms!frmPopupChangeEquipment.Form.Filter = "SerialNum = '" & SerialNum & "'"
Forms!frmPopupChangeEquipment.Form.FilterOn = True
End Sub
 

One question though, because I am using a navigation form, I cannot hard code the path as you see above. I need to use "Me."

...Not sure what that would be.

[mbizup]

Hi - Glad you worked it out. Filtering a mainform from it's subform is not a very common practice (it seems a little like the tail wagging the dog :-) )

If you haven't worked out your follow up question yet, try using the 'Parent' property instead of hardcoding. Ie:

Me.Parent.Filter = "Blah"
Me.Parent.FilterOn = True

[NeoPa]

In case of interest see Example Filtering on a Form.

Otherwise, Miriam has already given a very good answer to your question.

[ittechguy]

Thanks for the help! Me.Parent works perfectly.

Yea, I realize it seems backwards, but it does what I need it to do.