G
Gijs van Swaaij
Hey everyone,
I have a form in my database (frmRes) that lets users select several
criteria, based on which a report (repRes) is made. For instance, the
user can choose to show only those data that relate to a specific
person. This is done by generating a where clause in a VBA script when
the user clicks "OK". After the where clause has been generated, the
script loads the report repRes with it.
Now the problem is: frmRes has a checkbox on it (chkShowSub) that
should control whether or not repRes will display a subreport. If it is
selected, the subreport should be visible, otherwise it should be
hidden. Is there a way to make my form do this? I don't see a good way
to include this in my where clause without seriously hacking the way
the report is generated - and that would be some ugly hack! Ideas?
Thanks,
Gijs van Swaaij
I have a form in my database (frmRes) that lets users select several
criteria, based on which a report (repRes) is made. For instance, the
user can choose to show only those data that relate to a specific
person. This is done by generating a where clause in a VBA script when
the user clicks "OK". After the where clause has been generated, the
script loads the report repRes with it.
Now the problem is: frmRes has a checkbox on it (chkShowSub) that
should control whether or not repRes will display a subreport. If it is
selected, the subreport should be visible, otherwise it should be
hidden. Is there a way to make my form do this? I don't see a good way
to include this in my where clause without seriously hacking the way
the report is generated - and that would be some ugly hack! Ideas?
Thanks,
Gijs van Swaaij