Button to open report and close form

[dataheadache]

I've built a form which asks for data to search my database, once I select the data - I click the Preview button which sends the requested data to the query to bring up the report - on my form I have two button "Preview" and "Cancel" - I want to enhance the Preview button to close the form which requested the data automatically after it has loaded the report - how do I do this?

Any help gratefully received.

 

[Rich]

DoCmd.Close ?

 

[a.sinatra]

DoCmd.Close ?

OR as Mile's taught me....

DoCmd.Close acForm, Me.Name

OR

DoCmd.Close acForm, "frmName"

________
White widow seeds

 

[Rich]

OR as Mile's taught me....

DoCmd.Close acForm, Me.Name

OR

DoCmd.Close acForm, "frmName"

Yes, I do believe that's now required in the newer versions

 

[dataheadache]

Yes, I do believe that's now required in the newer versions

Thanks a.sinatra - that worked a treat - the problem with DoCmd.Close, rich is that after the report was opened, the report became the active window and if I just put DoCmd.close it would have closed the newly created report, and not the form - which is not what I wanted!!