changing report headings names

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks Tina, that should work.

tina said:
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
 
Back
Top