MS Access -- Data being deleted from a single field after being entered.
Posted on 2011-02-10
Have a new fun problem with one of my databases.
Using MS Access 2007
On a form with 100-150 (not really sure anymore) fields for data entry, the database is refusing to accept data for 1 field. It's a date field, one of many, and I haven't changed anything structurally in 2-3 months. But the users enter the information, save it, and when they reopen the record the data is gone.
Any idea why it's not saving?