Problem with a form/subform

[Casey Matthews]

I have built a database that uses ODBC to bring in
information from AS400. Using this information, I build
several tables, and have built a separate table that
includes all fields that are the basis for my subforms.
It is the fields from these subforms where my users enter
data. On entering data into the subform fields, using the
main form, there are often different errors, which I
unfortunately do not have all the details for, but they
are something to the effect of not being able to save due
to somebody else accessing the information (all though
nobody else is actually in the database anywhere else), or
some other similar error (I will try to post them as I
find them). The user is then unable to get away from teh
error message, and is required to ctrl-alt-delete and end
task. Then on reopening the database, sometimes the
information is still there, sometimes not. The user then
enters the necessary data, and prints and/or emails the
form. Somehow, the above errors are causing duplications
of the individual records being altered in the subform
table....Which then is printed/emailed out during the
print/email stage. Why is this happening and how can I
stop it?

Thanks!

Casey