I have it set to update a pretty big record. I'm able to save it fine with almost identical code but when I try to update it I get this error. The only difference is when I save it I wrote the query "select * from tblProducts order by item_ID" and for update I have it written "select * from tblProducts where item_ID=" & itemID. Does anyone know why I'd get an error? This is the only part that's any different.