I'm not sure what is causing this, but I have many forms that sum fields in detail section of the form. From time to time, the sum would yield #Error. I would then manipulate by compacting, deleting the cells, copy from a different form that has no issues, or other actions. For the most part, the sum would then work. However, my luck has run out with this particular form. I basically copy from a form that worked and removed a field in the query and deleted it the same field from the form. See Pics below (one works and one does not). However, whatever I do, I cannot get that #Error to go away. Any ideas on how I can resolve my issues?