requery subform based on check option

[aussiehedge]

I have read many articles and it just dosnt work for me. I am trying to refresh a subform when the check box is ticked on a single record in the subform to remove that line to limit the results via a query.

I have the following in After Update

Private Sub Option_AfterUpdate()
Me.frm4802.sfm4802.Form.Requery
End Sub


Main form: frm4802
subform: sfrm4802
query: 4802 Query

 

[VilaRestal]

Two things:

In the query put a Criteria on the Option field of
No

Change the code to
Me.Parent.sfm4802.Form.Requery