B
Bill Mitchell
Hi,
I am using DoCmd.RunCommand.FilterBySelection in one of
my shortcut menus. When I invoke on a subform it filters
successfully on the screen.activecontrol.value. But when
I try DoCmd.RunCommand.RemoveFilterSort to remove the
filter, it removes and filters on and requeries my Parent
form and not my Sub form.
Why is this and how do I work around it? I want to
remove the filter on only my subform.
I am using DoCmd.RunCommand.FilterBySelection in one of
my shortcut menus. When I invoke on a subform it filters
successfully on the screen.activecontrol.value. But when
I try DoCmd.RunCommand.RemoveFilterSort to remove the
filter, it removes and filters on and requeries my Parent
form and not my Sub form.
Why is this and how do I work around it? I want to
remove the filter on only my subform.