Last week I updated one of my forms with 156 new fields. Friday night when I closed the database everything was working fine.
When I came in this morning the form refused to load. Access would lock up and i would get a message that it was not responding. Eventually I was able to get it to load by opening the form in design view, then going into layout view, and then finally into form view. However none of my calculated field are functioning, with every single one returning a #name? error. Neither is any of my conditional formatting. I have double checked everything, and all the references are correct, and my conditional formatting is still there. It just isnt calculating.
Also, none of the broken fields are the new ones. They are fields that have been in this form for years, and I didn't make any changes to them with the recent additions to the form. All of the new fields are working perfectly fine.
What could possibly be causing this, and how do i fix it?