All versions of Access have a serious bug where they silently lose your
entry when you close a form if there is any reason why the record cannot be
saved. Details in:
Losing data when you close a form
at:
http://members.iinet.net.au/~allenbrowne/bug-01.html
The other case that often catches people out is that the data can seem to
disappear from a subform if you have not set your foreign key's Required
property to No. It is actually there in the table, but never appears in the
subform again, since the null foreign key does not match any record in the
main form. Note that this happens even if you have created a relationship
with Referential Integrity.
More information (and a 3rd case) in article:
The Query Lost My Records! (Nulls)
at:
http://members.iinet.net.au/~allenbrowne/casu-02.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps.org.
"R. Yang" <jy*****@gmail.com> wrote in message
news:cs**********@mailhub227.itcs.purdue.edu...
Hi,
I've a question regarding saving the data. I noticed some of my
recently-entered data mysteriously disappeared. There was nowhere to
re-locate them. Plus, those data were entered within the same week. My
colleagues and I have been cautiously avoided working on the same table
simutaneously. Any reason why the data got lost?
I appreciate your advice!
Yang
