The error is The database engine could not lock table 'ProdSum4' because it is already in use by another person or process. I get an action failed on my last query before my report when I use my command button to run my macro. However when I just run the macro, it works fine. Why do I get this error when all I have open is the database window and the form with the command button on it? What do I have to change to get my macro to run from the form?