R
RickJ
I have managed to do this on a form based on a normal query or table but not
on a Cross tab.
The way I did it was using an After Update linked to an Apply Filter Macro
on a combobox to select the criteria.
On the Macro Conditions I use the argument eg ([Forms]![SKU/Sales]![Select])
Is Not Null.
On the "Where Condition" I put [Main]![SKU
type]=[Forms]![SKU/Sales]![Select]
As mentioned this does not work when the form sources from a Crosstab request.
Not sure Im making any sense but I need to use the set Macro functions as I
do not know how to set up Modules.
Can anyone help me?
Cheers,
RickJ
on a Cross tab.
The way I did it was using an After Update linked to an Apply Filter Macro
on a combobox to select the criteria.
On the Macro Conditions I use the argument eg ([Forms]![SKU/Sales]![Select])
Is Not Null.
On the "Where Condition" I put [Main]![SKU
type]=[Forms]![SKU/Sales]![Select]
As mentioned this does not work when the form sources from a Crosstab request.
Not sure Im making any sense but I need to use the set Macro functions as I
do not know how to set up Modules.
Can anyone help me?
Cheers,
RickJ