Forms - Multiple Users - Record viewing in form

[cyb3rwolf]

Hello. i apologize if this maybe should be posted in the coding section but:
I have a form that allows users to navigate and update records. These
records are tasks that the different users can take ownership of by changing
the field "status" to take ownership of that record. Basically, i want to
make it so 2 users cannot view the same record at the same time. Example:
Let's say "John" is using the form, and he is currently looking at record 6.
Then Let's say "Tim" is using the form and starting at record #1, keeps going
to the next record. What i want to happen since John is currently looking at
record 6, when tim hits the Next button when he is on record 5, it would jump
to record 7. I have figured out a way to accomplish this (i have a field in
the table called "owned" and have VB code that whenever a user of the form
opens the form, it will only go to ones where "owned" is null, and then when
the go to the record, "owned" is changed to "Yes" and saved right away, and
then when the user navigates away from the record, "owned" is cleared out.)
This works so far, but for starters i am convinced it is going to be buggy
once a lot of people start using the form at the same time and also, I am
thinking there might be an easier, basic way to do it. Anybody help me out?
Or, maybe this questions should be posted in the coding section?

 

[John W. Vinson]

Hello. i apologize if this maybe should be posted in the coding section but:
I have a form that allows users to navigate and update records. These
records are tasks that the different users can take ownership of by changing
the field "status" to take ownership of that record. Basically, i want to
make it so 2 users cannot view the same record at the same time. Example:
Let's say "John" is using the form, and he is currently looking at record 6.
Then Let's say "Tim" is using the form and starting at record #1, keeps going
to the next record. What i want to happen since John is currently looking at
record 6, when tim hits the Next button when he is on record 5, it would jump
to record 7. I have figured out a way to accomplish this (i have a field in
the table called "owned" and have VB code that whenever a user of the form
opens the form, it will only go to ones where "owned" is null, and then when
the go to the record, "owned" is changed to "Yes" and saved right away, and
then when the user navigates away from the record, "owned" is cleared out.)
This works so far, but for starters i am convinced it is going to be buggy
once a lot of people start using the form at the same time and also, I am
thinking there might be an easier, basic way to do it. Anybody help me out?
Or, maybe this questions should be posted in the coding section?

Try setting the Form's Record Locks property to "Edited record". If a user
edits any field on a record, that record will become unavailable to other
users until the first user relinquishes it.

 

[cyb3rwolf]

Thank you for the reply, John, however that did not appear to work. I
changed the setting on the form, but when i did a test with one of my
coworkers, we were both still able to land on the same record at the same
time. Even tried to edit the record and my cowork was still able to navigate
to that record. Is there any other information on this?

 

[Rick Brandt]

Thank you for the reply, John, however that did not appear to work. I
changed the setting on the form, but when i did a test with one of my
coworkers, we were both still able to land on the same record at the
same time. Even tried to edit the record and my cowork was still able
to navigate to that record. Is there any other information on this?

It doesn't keep them from looking at it, but it will keep them from editing
it (or at least from saving those eidts).