Records don't save

L

Lanceu

I have a multi-user database (small) that has a few data entry forms.
It is split with a bit of obfuscative VBA code for error checking. (I
didn't build it but its in my charge)

The problem is that occasionally users are entering records and
clicking "save", and even though it confirms the save, the record is
not in the table. I believe this is after a chain of several records
is entered.
 
A

Allen Browne

Can you pin down when this occurs?

Might it be this bug:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html

Does it happen in a subform?
If so, might it occur when the main form is at a new record?

How do you "confirm the save"?
Is that a dialog in Form_BeforeUpdate?
The record could still fail to save after that for many reasons (e.g.
required field not entered, validation rule not met, violation of unique
index, lookup value required, ...)
 
L

Lanceu

Found when it happens-- it occurs when one tries to enter sequential
records without resetting form.
 
Top