Hide a From

[TxSteve]

err...that's "Hide a Form"

I am using Ken's code:
http://www.access-programmers.co.uk/forums/showpost.php?p=454581&postcount=8

and wanted to know if there is a simple way after the user enters the dates for the form to automatically close? It works great, but is a little annoying blocking the report until the user manually closes.

 

[Rich]

Toggle the forms Visible property

 

[Brianwarnock]

The parameter form has to remain open until the report is done.
Brian

 

[TxSteve]

So I guess that means there is no code that one could add to the button on the form to execute after the button click to call the report, that would then close the form window...bummer.

 

[Brianwarnock]

I've never done it but how about closing the form from the report load event, tho' I don't know if that is too soon.

Brian

 

[Rich]

Like I said, Me.Visible = False and then just Close the form on the Reports UnloadEvent

 

[TxSteve]

I added the your line to the following existing code and it worked beautiful. Thank you.

Private Sub Command4_Click()
On Error GoTo Err_Command4_Click

Dim stDocName As String

stDocName = "Closed By Case"
DoCmd.OpenReport stDocName, acPreview
-->Me.Visible = False

Exit_Command4_Click:
Exit Sub

Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click

End Sub