Access 2010 crashes when I close a report

[satishmen66]

I have a report which has the following code in "form open event property"

DoCmd.ApplyFilter, " "

After I preview the report and I close it, Access stops responding and following are the details of the error message
Problem signature:
Problem Event Name: BEX
Application Name: MSACCESS.EXE
Application Version: 14.0.4750.1000
Application Timestamp: 4b8bade7
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.4940
Fault Module Timestamp: 4ca2ef57
Exception Offset: 0006ccb5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 13313


Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.4750.1000
Application Timestamp: 4b8bade7
Fault Module Name: MSACCESS.EXE
Fault Module Version: 14.0.4750.1000
Fault Module Timestamp: 4b8bade7
Exception Code: c0000005
Exception Offset: 006d55e4
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 13313
Additional information about the problem:
LCID: 1033
skulcid: 1033
How can I overcome this problem

 

[Jeanette Cunningham]

Remove the line of code
DoCmd.ApplyFilter, " "

That code does not do anything useful. See if that stops Access from crashing.

 

[satishmen66]

I have the following code in the form "open" event

Docmd.applyfilter , "[amount]>0"

that is what I meant

If this code is there, after I preview the report and try to close it, Access stops responding and I have to restart the application again.

 

[Jeanette Cunningham]

Instead of putting that code in the report, put it in the record source of the report instead.
Base the report on a query.
In the design view of the query, put >0 in the criteria row for the column called 'amount'.