Requery a subform

[dkkirk2000]

Hello, I need help with a subform. I have filters and I can clear the filters but the subform stays on the last records that were filtered. How can I get the full list of records back?
Thanks in advance!

 

[dkkirk2000]

Thank you so much for your reply!
I watched your videos and I'm doing something very similar to what you have. I have 3 option groups, one subform and a "clear filter" button with this code:

Private Sub Clear_Click()
Me.cboCIname = Null
Me.grpChoice = Null
Me.grpPsdDue = Null
Me.grpWeeklyNotes = Null

Is it possible to have the button clear the filters and requery the subform to get all of the records back. right now it only shows the last filter applied.