changing report headings names

[Guest]

I would like to give the user the option of changing the report heading
names, I can do this with the Docmd.openreport, stdocname,
acviewdesign,,,achidden and then grab the current heading and display that
heading and allow the user to change it. I then do a docmd.close acreport,
stdocname, acSaveYes, this works just fine when I test but when I compile the
program into a mde it doesn't like the it. Is there another way of doing
this? Thanks for any help.

Tom

 

[tina]

you can write the current heading names to a table, making sure the table
holds only one record. add the table to the query that the report is based
on. use textbox controls to display the heading names in the report. display
the table to the user *via a form*, where s/he can change the heading names
as desired.

hth

 

[Guest]

Thanks Tina, that should work.

you can write the current heading names to a table, making sure the table
holds only one record. add the table to the query that the report is based
on. use textbox controls to display the heading names in the report. display
the table to the user *via a form*, where s/he can change the heading names
as desired.

hth

 

[tina]

you're welcome

Thanks Tina, that should work.