T
Terry
The subreport and a main report both use the same recordsource query, the
subreport just displays the data in a different way. The subreport appears
in the report footer and is only shown on the last page.
The query gets it's criteria values from a form combobox control, which may
be empty or have a value, so the criteria applied to a field in the query is
LIKE forms!frmName!comboName & "*" OR IsNull
The criteria returns all matches for the combobox values and also those
where there is also a Null value in the field. I can filter out the Nulls by
including the combobox value in the criteria section of the
DoCmd.OpenReport, but that is only good for the main report, the filter will
not apply to the subreport which would still include the rows with null
values.
Is there a better way to do this so that the queries get correctly filtered,
or correctly filter the subreport?
Regards
subreport just displays the data in a different way. The subreport appears
in the report footer and is only shown on the last page.
The query gets it's criteria values from a form combobox control, which may
be empty or have a value, so the criteria applied to a field in the query is
LIKE forms!frmName!comboName & "*" OR IsNull
The criteria returns all matches for the combobox values and also those
where there is also a Null value in the field. I can filter out the Nulls by
including the combobox value in the criteria section of the
DoCmd.OpenReport, but that is only good for the main report, the filter will
not apply to the subreport which would still include the rows with null
values.
Is there a better way to do this so that the queries get correctly filtered,
or correctly filter the subreport?
Regards