On Open Event in a report

M

MAM

Hello...
I have created a report, when I run that report I would like to have an "on
Open Event" that opens up a small form that I can click that will export the
report to word.
The form works fine, but I cannot get it to open when the report does.
Any help would be appeciate!

BTW - I love this site, and have found i exteely helpful!
Thank you
Mary Anne
 
J

John Spencer

In the report's open event, you should be able to add VBA code to open a form.

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "NameOfTheForm"
End Sub


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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 with buttons to open forms 6
control on form from report 2
Can't open a form on top 8
Filtering subreports on main report 0
Reports and Sub Report 6
On Open Event - Run query 2
Can't create a report from my query in Access 1
access report 0

Top