Closing a form when a report opens

T

Tony Williams

I have a prompt form that the user selects which records to run a report on.
When the report opens I want the form to close. I've used this simple code
but it doesn't work. Anyone help?
Private Sub Report_Open(Cancel As Integer)

DoCmd.Close acForm, Me.Name

End Sub

Thanks
Tony
 
D

Douglas J. Steele

Me refers to the currently active object. Since that code is in the report's
Open event, "Me.Name" refers to the name of the report. You'll have to
replace that with the actual name of the form:

DoCmd.Close acForm "MyFormName"
 
T

Tony Williams

I've used this Doug
Domcmd.Close acForm frmviewid
and i get an error message

Runtime error 2493
This action requires an Object name argument

What have I done wrong?
Thanks
Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report skips through form with parameters 7
Dynamic Naming of Form Button 3
Main Report without Data 1
Parameters requested twice when opening report 2
Access2007 won't run report event procedures (e.g. Detail Format) 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Detail_Format works in Print Preview but Not When Printing 0
How to programatically add an existing report to a report (as sub) 2

Top