This is a bug that's been in Access forever.
Losing data when you close a form
As the article explains, the workaround (once you are aware of the problem)
is to explicitly save before closing.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.