Solved Unfilter subform after combox selection (1 Viewer)

VzqCrs

Member
Local time
Today, 07:18
Joined
Nov 15, 2021
Messages
54
I have a subform that OnLoad will filter by the current user but sometimes they'll need/want to see other tasks (primarily for supervisors).

So the OnLoad of my SubForm filters on the current user.
On the main form, which only contains the combobox to select another user the parent/child relationship has been made and everything works fine until I added the filter on load.

How can I - on the combobox AfterUpdate event, unfilter the subform?
 

Minty

AWF VIP
Local time
Today, 11:18
Joined
Jul 26, 2013
Messages
10,355
Simply use

Me.YourSubformControlName.Form.FilterOn = False
 

Users who are viewing this thread

Top Bottom