Please check out the following link. You may want to scroll to the bottom where the information indicates that VBA code just randomly disappears.
Has anyone experienced this and found a way to retrieve it other than a backup copy. It appears to be Access 2007 related. Has anyone experienced this with Access 2010.
http://www.pcreview.co.uk/forums/thread-3817593-3.php