Report Problem

[Don S.]

I am using MS Access 2007 and I have a switchboard on which I have several
buttons to run various reports. Since I want to have the ability to put a
specific year on a report and may run several reports at the same time, I put
an unbound control [RptYr] on the switchboard to enter this 4-digit year .
On each report I have an unbound control that pulls the year from
[Forms]![Main Switchboard]![RptYr] to enter into the report. [RptYr] has no
special formatting and I enter the year 2007.

These have been working really well until yesterday when one of the reports
“Capital Items†would not work. I can click on several reports and they will
be fine and then go back and click on “Capital Items†it will then work.

The message I get is:
The expression On Open you entered as the event property setting produced
the following error:
Return without GoSub.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

When I click the “Show Help†button I get the following message:
“This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set to =[Field], this error occurs
because Access expects a macro or event name to run when the event is fired."

I recall that when I had successfully run the report earlier in the day I
accidentally closed the database before closing the report. Could this have
corrupted the database although everything else works fine.

Thanks for your help.

 

[Don S.]

One additional comment. "On OPen" I have the following which I put on most
of my reports:

Private Sub Report_Open(Cancel As Integer)
DoCmd.Maximize
End Sub