Hi CementCarver
I am currently trying to accomplish this exact scenario. Like most people, I have the code working on the main form but unable to get it to work on the subform. Would you be able to tell me where you placed the code you pasted above? Was this on an event on the actual control? Or is it a module that is called from an event? etc......
Any help you can provide would be greatly appreciated.
Thanks