saving report in runtime

[Richard]

Hi

at runtime, how would I close a report and save it as another name?

I need to open a report in design view, add a few text boxes, close it and
save as another name, then open the report.

I can open it without saving but when the user closes the report it will
prompt to save. Or is there a way to work around it?

Appreciate the help..

Many thanks in advance
Richard

 

[John Spencer]

Normally I would just have additional controls on the report. You can set
their visible property to NO and when needed set the visible property to Yes
and assign a value to them for the duration of the report. You can temporarily
change the properties of the controls - such as position and size - as needed.

As long as you do this in VBA and in the Open event of the report you don't
need to switch to design view and you should not be prompted to save the
changes to the design

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County