Refresh Button Code

[Bateman28]

Hi

Can anyone help me, i have a form that has multiple records that is access
by different users. Once a user has entered into the record the record is
assigned to them. What i would like is a refresh data button on the main
data form so that each agent can simple click the refresh button so they dont
access the same record as another user....also if possible i would like to
know how a message can appear if an agent is already in the record so that
the user knows to leave that record and try another record.

Any Help would be great....cheers

 

[Dorian]

You must avoid having a form with more than one record. I would have a list
of records displayed in a Listbox with one column being agent's id, this
would be blank for unassigned records.
Once an agent selects a record, you immediately update the record with their
agents id and then switch to the form to handle the single record.
Each time an agent finishes with a record and returns to the list form, the
list refreshes and thus shows all new records that have an agent assigned.
The only gotcha is if 2 agents select an unassigned record at the same time.
Then what will happen is that the first one to update the record will succeed
and the second will fail and have to go back and select another record.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Bateman28]

Sorry I should have said, the form is a continuous form, would this make any
difference??