Requery a subform (1 Viewer)

[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!

 

[Uncle Gizmo]

You probably need to requery your subform window. (It's not really a subform window it's called a subform/subReport control) the code would look something like this:-

SubFormWin.Requery

Where "SubFormWin" is the name of your subform/subreport control, a hard to find control which surrounds your subform. It's not part of your subform it's a container for it / around it.

I recently did a YouTube video with an explanation (in a slightly different situation) which should prove useful.

You can see it here:-
https://youtu.be/uchI_ubZrAI?t=05:20

Go to time index 05:20

 

[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.

 

[Uncle Gizmo]

I already explained how to do it in my previous post

Sent from my SM-G925F using Tapatalk