Change to design view of report in code

I have to change the report sorts in code depending on what the user selects on the selection form. I also need to change the group footers by using the CreateGroupLevel method. I can't use this unless the report is in design view. Is there a way to change the report to design view in code? Keep in mind when I bring up the filter form for the user to make his sorting selections, I have already opened the report, bringing up the form in the Open_event of the report.

Thanks in advance for any help.

What about OpenReport? Does that allow design view?

The report is where I need to make a change that will only allow it in design view. This is not multi-user, so that won't be an issue.

Thanks!

Now, how do I gracefully close the design view?

I now know how to open the report in design view, change the groupings, but after the report opens up in Preview and the user closes it, what is seen is the report in design view. Of course, I don't want the user to see this. Pat, you must have run into this before?

Any help is appreciated.