Toggle between form and report

[Mya48]

I have a form that has a preview report button on it to open up my products
list report. I don't like that the report opens up in full screen and the
only way to get back to the form is to close the report.

Is there a way to “toggle†back and forth without always being completely
closed out of the form?

I'm using Access 2007.

 

[KARL DEWEY]

Did you try adding a button on the report to call a macro to open the form?

 

[Mya48]

I thought reports aren't interactive. I tried adding a button like you said
but you can't click a command button on a report.

 

[KARL DEWEY]

It works if you are in Report View but not in Preview or Layout.

 

[Mya48]

Thanks it works great but if I use this view my photos don't change with each
record. It only works in Print Preview. Do you have any idea how to fix
this?

 

[KARL DEWEY]

Nope. I do not get that fancy.

Thanks it works great but if I use this view my photos don't change with each
record. It only works in Print Preview. Do you have any idea how to fix
this?