Don,
Thanks for the response. I should have mentioned up front that I'm using Access 2007, it doesn't create buttons with VBA, it creates macros. Can this code be used in a macro some how? I tried making my own module with your code, but it did nothing when I clicked on the button.