L
Leslie Isaacs
Hello All
How do you use the ApplyFilter action in a macro?
I have a query [qry_show_p45s] that takes as its record source
[qry_showAll]. [qry_showAll] is the record source for a form
[frm_employees]. I have a button on [frm_employees] with the OnClick event
set to run macro [mac_show_p45s], and this macro just has an ApplyFilter
action, with [qry_show_p45s] as the filter name argument. The problem is,
when I click the button on [frm_employees], all that happens is that the
existing filter (which was loaded as part of the form's OnOpen event) is
removed, and I am left with every record showing from [qry_showAll].
What have I done wrong?
Hope someone can help.
Many thanks
Leslie Isaacs
How do you use the ApplyFilter action in a macro?
I have a query [qry_show_p45s] that takes as its record source
[qry_showAll]. [qry_showAll] is the record source for a form
[frm_employees]. I have a button on [frm_employees] with the OnClick event
set to run macro [mac_show_p45s], and this macro just has an ApplyFilter
action, with [qry_show_p45s] as the filter name argument. The problem is,
when I click the button on [frm_employees], all that happens is that the
existing filter (which was loaded as part of the form's OnOpen event) is
removed, and I am left with every record showing from [qry_showAll].
What have I done wrong?
Hope someone can help.
Many thanks
Leslie Isaacs