Reports w/ parameter queries

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I read the article written at the following URL.
(http://office.microsoft.com/en-
us/assistance/HA011170771033.aspx) However, I am having
a little problem. I am attempting to use this
information in a database that I have developed myself.
I have followed all of the steps and I can't find
anything different. After entering the VBA code for both
the report and the form(the dialog box used to request
the parameters) I go ahead and try to run the report.

Each time I do I get an error on the following line:

Private Sub Report_Open(Cancel As Integer)

The error says that it is a compile error: the sub or
function is not defined. At this point I click OK and
the line mentioned above is highlighted. Any ideas? Am I
doing something wrong?

Unfortunately, I have never used VBA before and I am
pretty much experimenting for the first time. Anyway
help would be greatly appreciated.
Thanks
 
Press F8 to step through your code to find the actual line giving you the
error.
 

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

Back
Top