Hi Nathan, When we try to help with an issue like this, we need as much information as possible to solve the problem. Show us the code that runs the macro. (screen clip). Are you using a query or a table. If it is a query then show us the query. give us a screen clip of the query.

John

Sometimes you can't save records.  This is usually indicated by a greyed-out Save button in the ribbon (see picture below).  If you run code that tries to save when it can't, you get an error.  When you get the error, take a peek at the ribbon.