Is there any way to modify reports on-the-fly?

[thrainpa]

Hi,

In my project I use reports to build and print out letters, but someone noted that after generation there is no easy way to make changes to the report.

I tried going into 'Layout' View but some of the code queries the database via SQL and going into layout mode breaks it.

Is there another way I do not know about?

 

[thrainpa]

I apologise if I should have made a new thread for this but since it is related I thought it should go here.

Firstly, I made a form that loads up the value of a textbox (there are 2) in the report. By putting something like this in the OnLoad section of the form:

Me.TextBox1.Value = [Reports]![ReportName]![TextBox1].[Value]

And on the Keyup of the form I have it refresh the box in the report with:

[Reports]![ReportName]![TextBox2].[Value] = Me.TextBox1.Value

This does not work and I get an 'Object Required' Error at this part of the code, does anyone have any idea how I can fix this?

Thank you in Advance.

 

[vbaInet]

What are the users trying to change on the report?

Have you considered exporting the report to Word?