I have form1 collecting two values. form2 has calculations that refer to the values collected in form1. For example: [Forms]![form1]![field1]+[Forms]![form1]![field2]. But this only works when form1 is open. Once form1 is closed, all calculations in form2 give an error (#Name?). I am an Access beginner and obviously there is something I am missing. I spent 8 hours yesterday reading Access forums but unfortunately I still can't make this work as I couldn't find a clear solution. Any clues?