[AccessD] Suppress Sub reports with conditional IF

I am writing a form letter via a report, (mail merge did not work for this
one). I need to suppress or show two sub reports on this report depending
on the value of a field.

There is a field on the Report named Status which is either refused or
approved. If it is approved I need to show Appsubrep and if it is refused
Groundsrefrep. As they both contain text as well as Data just placing them
on top of one another and letting the one with data show won't work in this
case.

Should I do this in the Onload of the form using a conditional IF on the
visible property of the sub reports? Does anyone have a better/more
appropriate solution?

All help greatly appreciated.

Connie Kamrowski

Analyst/Programmer
Information Technology
NSW Agriculture
Orange





This message is intended for the addressee named and may contain
confidential information. If you are not the intended recipient or received
it in error, please delete the message and notify sender. Views expressed
are those of the individual sender and are not necessarily the views of
their organisation.