update record event

What event can I use to catch when one front end sees a change that
another has made? So like if one person entered something in a front
end form/record and another was on the same form/record and saw the
change. That's what I want to catch. I tried using the onchange or
afterupdate events for the textbox that changes but it did not work...

thanks

re: update record event

As far as I know, there is not an event that fires when someone else changes
a record you are working on. You may get an exception when you finish
editing and try to write it. That is the point at which "collisions" are
handled.

Larry Linson
Microsoft Access MVP

"ken" <gevayl@gmail.com> wrote in message
news:1123366936.809527.232160@o13g2000cwo.googlegr oups.com...[color=blue]
> What event can I use to catch when one front end sees a change that
> another has made? So like if one person entered something in a front
> end form/record and another was on the same form/record and saw the
> change. That's what I want to catch. I tried using the onchange or
> afterupdate events for the textbox that changes but it did not work...
>
> thanks
>[/color]

re: update record event

actually when the form refreshes its not really a collision that I'm
interested. I have a field that locks the form if you are on that
record. So if one person locks the reord while another is viewing it,
since no event can detect the refresh I can't lock the other persons
form(on that record only)

re: update record event

I have 2 form. One payment, and anothers amount owing, when I updated
the payment, the 'amount owing' automatically get the correct number.
And it is based on a query. I don't know why this is happening, but it
is a good thing.
My question is how to lock the form on a field?

re: update record event

What to you mean lock the form on a field? So that the user could't go
to the next or previous records?