Using a form to list report objects problem

[Skip Bisconer]

I have a form that lists all the reports available in the database so the user can selectivly preview or print any report they need. My problem in the I want the form to be a pop-up but when I have that property set I can't get the form out of the way of the report preview. I can close or minimize the form but don't know how to get it to restore after I click the Close Preview screen. Any help would be appreciated.

 

[RuralGuy]

Just set it invisible while the report is open.

 

[RuralGuy]

You are also going to want to use the acDialog argument to stop the code at the OpenForm line until the preview is closed.

 

[Skip Bisconer]

Thank for responding RG,
I don't have a problem making the form go away it's getting it back when I close the report preview. Where would I put the code to get the form visable again? You and I were at it at the same time. Thanks I will give a try.

 

[Skip Bisconer]

I am not very versed in VBA but I have tried this code on my Preview Report button's click event but it doesn't pause the code for me. Do I have it in the wrong place?

Private Sub cmdPreview_Click()

Me.Visible = False
DoCmd.OpenReport Me.ReportList, acViewPreview, "", "", acNormal, acDialog
Me.Visible = True

 

[RuralGuy]

DoCmd.OpenReport Me.ReportList, acViewPreview, , , acDialog

 

[Skip Bisconer]

Thanks again RG

 

[RuralGuy]

Glad I could help.