O
Opal
I have a report that is generated based on the value selected by the
user
from a combo box on a form. The user selects an area from the drop
down box and a report is generated with the following criteria in the
select
statement of the query:
[Forms]![frmSelectrptArea]![Area]
The user has 10 areas to select from. I also want to be able to use
the DoCmd.OutputTo method to generate a rich text format of the
report.
How can I create a specific .rtf file by area? These .rtf files are
to be
emailed to users in the areas noted to act on.
Can anyone offer an advice?
Thank you.
user
from a combo box on a form. The user selects an area from the drop
down box and a report is generated with the following criteria in the
select
statement of the query:
[Forms]![frmSelectrptArea]![Area]
The user has 10 areas to select from. I also want to be able to use
the DoCmd.OutputTo method to generate a rich text format of the
report.
How can I create a specific .rtf file by area? These .rtf files are
to be
emailed to users in the areas noted to act on.
Can anyone offer an advice?
Thank you.