Here's a code that works for me.

I am using Windows 7 with Office 2007.

This code is in the On Click properties of a control button, on a Form in Access 2007.

When I click the control button...