D
dave b via AccessMonster.com
I have a report that I want to change the header information based on Product
Type. Product Type is tied to Product ID. Product ID is a three alpha field.
Product Type can be 1, 2, 3. It is not in order with Product ID. For
example you could have
ABC 2
BAC 1
CBA 3
I'm sorting on Product Type, so the headers only have to change twice.
Product Type is part of the query that the report gets its information.
There is also a filter that is activated on the Report Open event. When I
open the report from the form where the user enters the parameters, I get an
error: You entered an expression with no value. And highlights the line
that determines the value of txtProductType (Product Type) in
PageHeaderSection_Format.
It's apparent that the data is not being pulled from the query before the
Page Header event is fired. So, how do I ensure that the data is available
before the Page Header event? Can I access the query field? Should I pull
the data programmatically from the report, rather that have a query? Is
there another angle?
Type. Product Type is tied to Product ID. Product ID is a three alpha field.
Product Type can be 1, 2, 3. It is not in order with Product ID. For
example you could have
ABC 2
BAC 1
CBA 3
I'm sorting on Product Type, so the headers only have to change twice.
Product Type is part of the query that the report gets its information.
There is also a filter that is activated on the Report Open event. When I
open the report from the form where the user enters the parameters, I get an
error: You entered an expression with no value. And highlights the line
that determines the value of txtProductType (Product Type) in
PageHeaderSection_Format.
It's apparent that the data is not being pulled from the query before the
Page Header event is fired. So, how do I ensure that the data is available
before the Page Header event? Can I access the query field? Should I pull
the data programmatically from the report, rather that have a query? Is
there another angle?