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
 
Back
Top