<tr*****@gmail.comschreef in bericht news:11**********************@m79g2000cwm.googlegr oups.com...
Hello all,
I have a report that displays four pieces of data by default, but two
of these fields are not neccessary for all people to see.
I have made a form that gives the user the choice to select what data
to display when the report is being run. After the selection has been
made on the form, the report is opened in design mode, saved, closed
and reopened it in preview mode. I was wondering if there is a cleaner
way to modify the report than opening it in deisgn, and then reopening
it in preview mode?
Tim
You could do this in runtime, while the report opens
On your report I would make the choice-controls invisible.
On your form e.g. called FrmDisplayChoice you need two controls like
ShowControl1 and ShowControl2 (yes/no values here)
Then you need some code in the report's open-event like
Me!Control1.visible = Forms!FrmDisplayChoice!ShowControl1
Me!Control2.visible = Forms!FrmDisplayChoice!ShowControl2
Arno R