Does each user have a separate copy of the front end? That's what splitting
is all about.
Could it be this issue:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html
Is there code cancelling events like Form_BeforeUpdate without notifying the
users?
Any error-handling that simply suppresses the message?
On Error Resume Next is the worst kind.
Do you have foreign key fields without the Required property set to True? If
so, users can enter records in a subform when the main form is at a new
record. Those records never show in the subform again (although they are in
the table), because there is no record in the main form that will bring them
up.
Are these records being added via SQL statements or action queries? If so,
see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
I have a database on a server, it has been split into front-end/backend.
When employees enter data on a form (that inputs results directly into the
table), some of the data never shows up in the table.
Any reason why this might happen?
