Requery on back end causing multiple records on front end!

[Guest]

I have an app done in front end/back end style, with the database on the
backend and the user app on the front end. Users enter new records on the
front end app. I have a seperate app running on the backend allowing that
user to print forms for the new records entered by the front end users.
Problem is... To be sure the new records are available on the backend app, I
use a me.requery command to get the latest added records into the recordset.
This appears to cause SOME of the records in the process of being entered on
the front end to write their current info to the current record and then
create a NEW record to which the remainder of the data entry gets posted!
It's MADDENING!!! What's going on here? It doesn't happen EVERY time, but it
does happen SOME times. What would case a requery on the backend to cause the
records being created by the frontend users to split like that?

TIA for your help!

 

[Rick Brandt]

I have an app done in front end/back end style, with the database on
the backend and the user app on the front end. Users enter new
records on the front end app. I have a seperate app running on the
backend allowing that user to print forms for the new records entered
by the front end users. Problem is... To be sure the new records are
available on the backend app, I use a me.requery command to get the
latest added records into the recordset. This appears to cause SOME
of the records in the process of being entered on the front end to
write their current info to the current record and then create a NEW
record to which the remainder of the data entry gets posted! It's
MADDENING!!! What's going on here? It doesn't happen EVERY time, but
it does happen SOME times. What would case a requery on the backend
to cause the records being created by the frontend users to split
like that?

TIA for your help!

It's something else and whatever it is it is ALL happening on the front ends
of the users entering records.

Do yourself a big favor and give the user currently hosting the back end his
own front end and move the back end to a separate box.