Where is your command button from, the Form Toolbar or the Control Toolbar. The right click Assign Macro is for the Form Toolbar Command button. If you use the Control Toolbar Command button , you right click and choose view code. Place you macro in this module.