H
heidii
I need help.
I have succuess fully applied the "how to create a dynamic crosstab
report in access" from instructions off of microsofts web site to my
own report and query.
My problem is this.
I have a form in datasheet view, based off a query. When the form is
open I can hide / unhid columns as needed and apply filter by form.
That all is great. But now I want to beable to send the filtered data
on the datasheet form to the Dynamic Report I created showing only the
filtered records and also only show the columns that I did not have
hidden on my form.
How do I do this?
I have tried inserting into the code from microsoft on the On Open
event of my report to apply the filter from my form, but it does not
seem to work, because my reports record source is the underlying query
from my form, not the form. But can't seem to get the corret syntax
or the right location in microsofts code to apply the filter.
Any help would be greatly appreciated.
heidi
I have succuess fully applied the "how to create a dynamic crosstab
report in access" from instructions off of microsofts web site to my
own report and query.
My problem is this.
I have a form in datasheet view, based off a query. When the form is
open I can hide / unhid columns as needed and apply filter by form.
That all is great. But now I want to beable to send the filtered data
on the datasheet form to the Dynamic Report I created showing only the
filtered records and also only show the columns that I did not have
hidden on my form.
How do I do this?
I have tried inserting into the code from microsoft on the On Open
event of my report to apply the filter from my form, but it does not
seem to work, because my reports record source is the underlying query
from my form, not the form. But can't seem to get the corret syntax
or the right location in microsofts code to apply the filter.
Any help would be greatly appreciated.
heidi