I copied some code today for an Access 2007 project. Just couldn't get it to work. I finally looked very closely at the code. Do you see the difference between the two lines above? The top line works correctly. The bottom line does not.The bottom line looks like the code that I copied. Notice the opposite facing quote marks. They don't work in Access 2007 VB. Go figure. Looks like the author of the post that I got this code from was writing his article with an MSWord editor and it "corrected" his code for him.
