Edit Results

[ShadeRF]

I have a report based on a query with many different formulas. I need to be able to make it so when a user views the report they can adjust certain #s on the report and have it automatically recalculate the other #s based on their adjustments. I can upload the database to see if they think they could provide assistance. thanks!

[boblarson]

You can't edit directly on a report. But you can have a form open to do the edits and then the way to refresh the report is to have it close and reopen. You can do that without it appearing to happen to the user by using

Application.Echo False

before you do the close and reopen

and then

Application.Echo True

when done with that.