Search results

THAT part (Me.Dirty = False) works okay for me -- I'm using Access 2002, with SQLServer 2000 (MSDE actually) on the back-end. The code only fails later on for me with SQL syntax errors because the form's Me.Filter returns a 'where' clause in Access/Jet's SQL syntax, not SQLServer's T-SQL...

I've been working to solve the exact same problem in my own project, and I BELIEVE that this code will do what you want (although it may not be very efficient). Unfortunately it does NOT work in my case as I'm using a .ADP project (Access front-end with SQLServer back-end). Good luck, please...