Hey all.

I'm going to work on a multi (less than 10) user database and I intend to
split it into f/e and b/e. I want to make sure that I am arcitecting the
thing properly. I want to use a bound form because the users will not be
ENTERING new records, they will instead be EDITING existing records. The
users will enter some info into blank fields and then click on a button to go
to the next record.

What I want to make sure that I don't have two users trying to edit the same
record at the same time. If two people are working simultaneously, and one
person has a record open, no one else can get to that record when they click
on the "Next Record" button. What do I need to do to check/prevent this from
happening?

Thanks.