User Form setup

G

Greg H.

I’m not sure how this can be done but here is the situation. I have a table
of records that users will take that information and input it into another
program. When completed they will click the checkbox that will indicate its
done. Because I will have approx 3 people working in the database doing
this, I don’t want the same record to be worked on by more then one person.
What I need is a way for a user to be given a new record and when a second
person tries to pull up a record to work on, it will not pull back one that
is currently being worked. How can this be done? Thanks

PS if this did not make sense, let me know and ill try to explain again.
 
P

Pieter Wijnen

A rather simple & dirty way to do it is record the ID that each user is
working on in a table & lookup to see wether it is available for edit
this is offcourse susceptible to crashes, etc (the dirty part)

HTH

Pieter
 
G

Greg H.

How would i do that? Is there a way to flag a record before it is saved as
completed so that the next person who is working on the table at the same
time does not get thta same record?
 
Top