Goto Main form after report preview.

[cicicw]

Good Day All,
I hope to divert the user back to the main form (where I have my action buttons; add new, search edit) after they have close the report preview.

Right now, after closing report preview, it takes them back to the query table.

I hope to get some help on this.

Thank you for your time.

Regards.

 

[vbaInet]

On the Close event of the report you need to put something like this:

DoCmd.OpenForm "NameOfMainForm"

 

[cicicw]

Dear vbaInet,
Thank you for taking the time to help me out. I have tried the solution that you have recommended but to no avail.

I have attached a slide below which explains how I have tried to implement the recommended solution.

Thank you for your time.

Regards.

 

[vbaInet]

Is there any reason why you commented the code? i.e. why is there a single quote preceding the code?

 

[Insane_ai]

Check the report's "Has Module" property. I have run into the problem where code is not executed because the property fails to update when adding an event.

 

[boblarson]

Is there any reason why you commented the code? i.e. why is there a single quote preceding the code?

Yeah, I was wondering that too. But one line has me wondering:

after closing report preview, it takes them back to the query table.

What do you mean back to the query table?