Stop combo box refreshing

[braddles]

I have a form with a combo box on it, used to select staff members.

When I select a staff member it displays a list of tasks assigned to this staff member in a sub-form.

This is all working as I want - however, when another user (on another computer) selects a different staff member from the combo box, after a short time, that second staff member is displayed on my screen and consequently the second users tasks are aslo displayed.

How can I stop this combo box updating every time someone else selects a value?

 

[misscrf]

I would think that maybe making edits exclusive would work. make it so that only one person can work on a record at a time, then it wouldnt try to take the other users record and bring you to it. You may have to tell it on err to stay where it is.

misscrf

Management is doing things right, leadership is doing the right things