P
plh
Hi All,
I want to be able to filter the form based on the value in a combo box or other
control, then pass that filter on to a report which is opened by a command
button on the same form. The user would right click on the control, choose
"Filter by Selection", then open the report which should show up with the same
filter. What is the best way to do that?
On a related note, I notice that following the use of the "Filter by Selection"
option, if I use the "Remove Filter Sort" option, then look at the properties
for the form, the filter is still listed there. (I was trying at one point to
pass the filter to the report as a WHERE condition, which not only failed in the
case of the combo box filter (A window came up asking for a Parameter), but
cased these left over filters to persist (when opening the report) until removed
from the form properties manually. ).
Thank You,
-plh
I want to be able to filter the form based on the value in a combo box or other
control, then pass that filter on to a report which is opened by a command
button on the same form. The user would right click on the control, choose
"Filter by Selection", then open the report which should show up with the same
filter. What is the best way to do that?
On a related note, I notice that following the use of the "Filter by Selection"
option, if I use the "Remove Filter Sort" option, then look at the properties
for the form, the filter is still listed there. (I was trying at one point to
pass the filter to the report as a WHERE condition, which not only failed in the
case of the combo box filter (A window came up asking for a Parameter), but
cased these left over filters to persist (when opening the report) until removed
from the form properties manually. ).
Thank You,
-plh