We're not there. We don't know how your data is structured, nor how you've
organized/structured your forms for data entry.

It sounds like you want to prevent existing records from being modified, but
allowing existing records to be edited "while entering data". These seem
mutually exclusive.

Once you (Access) leave a form, the data is saved. Could you consider
working with a tab control, so the form isn't actually "left" when you go
from tab to tab?

Regards

Jeff Boyce
Office/Access MVP

"Geogeek" wrote in message
...
I've split my test run and most everything works great. However, how do I
provide a multi-user environment that does not allow each user to
view/access
existing records (to prevent accidental data overwritting, etc.), but at
the
same time allow the user to "Go Back" to a previous page (form) to make
edits
while entering data?

I've performed all the trial-by-error methods that I can think of, in
addition to reading the "Access Bible", but I can't seem to get over this
last major hurdle. Please help before I hurdle myself over something very
high and steep!

Mucho thanks!!!