All form data is not showing up in table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form for my staff to enter their daily productivity. However, it
appears that some of the data is not populating into the table. I reviewed
the steps to complete the form and watched as one of my employees entered the
data. Everything seemed right, but the info didn't reach my table? Is there
something I need to do since multiple users have the form open at the same
time?

Thanks
 
Access will silently lose the last entry you type into a form if you then
use the Close action/method to close the form. This happens if there is any
reason why the record cannot be saved, e.g. a validation rule that is not
met, or a required field that is not filled in. The really annoying part is
that it does not tell you the record was lost. Details in:
Losing data when you close a form
at:
http://members.iinet.net.au/~allenbrowne/bug-01.html

There is another issue where records seem to be lost (but are not). This
happens if a main form is at a new record, and you make an entry in the
subform. The record is saved with a null foreign key, so it never appears in
the subform again, even though it is in the table. To prevent this, set the
Required proprety of the foreign key field to Yes (in table design view).

It is also possible that there is some kind of corruption of the database
due to everyone using the same file, but I would expect you to see cryptic
error messages if this were the issue. It would certainly be preferable to
split the database and give each workstation its own local copy of the front
end. More info in:
Split your MDB file into data and application
at:
http://members.iinet.net.au/~allenbrowne/ser-01.html
 
Back
Top