Hey guys,
I am experiencing the same problem that L'apprentis was facing, and upon trying your solution I have stumbled across an error of my own.
First of all, I am new to Access, I have this in my VB code, but don't if that's where it's supposed to be or if I wrote the Macro correctly...