Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto close parameter querry form 1

Status
Not open for further replies.

Bill0722

Technical User
Jul 1, 2006
29
US
When I run a report off my switchboard, the command first runs a small form to imput the date range, and then when I exit that form, it runs the report. I'd like to be able to automatically close the parameter querry form, as it remains open. If I put a Close.form command in the event procedure before the opening of the report, the report doesn't open. Any ideas tips would be great.

Bill
 
Hi

I use the following code on the OnClick event of the 'OK' button of my parameter forms and it works perfectly

Private Sub ok_Click()
Me.Visible = False
End Sub
 
Thanks so much. Excellent tip, works great.

Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top