Jack and Pat
drawbridgej at sympatico.ca
Tue May 5 06:06:33 CDT 2009
Rocky, Don't know if this helps, but I did find this Filter related email from 2005 in my archive. Jack -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, May 05, 2009 12:47 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Setting Filter Error Dear List: We've been over this before I think but I can't find it in the archives. An mdb in 2003 runs the code: Me.FilterOn = False Me.Filter = "" just fine. But when I run that mdb in A2007 the line Me.FilterOn = False throws an error: Error 2001: You canceled the previous operation. Oddly, very oddly indeed, if I click Debug, and the F8 key, I can step through that line of code with no problem. Does anyone have a clue here what could be causing this? BTW, I also get this same error in this form with: Me.OrderByOn = False Me.OrderBy = "" MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/>