After Update

[Jacob]

On my After Update on a form. I have it populate 2 fields showing who was in
there and what time the changes were made. The problem is, after the after
update fires, I can no longer navigate to the next record. It seems to lock
up. Is there a script that will allow me to continue. Here is the code I
used on my After Update...



Me.[Datemo] = Now()
Me.[Modifiedby] = user

[Rick Brandt]

"Jacob" <jacob@intermed1.com> wrote in message
news:Ol1lH%23TTDHA.1324@TK2MSFTNGP11.phx.gbl...

> On my After Update on a form. I have it populate 2 fields showing who was in
> there and what time the changes were made. The problem is, after the after
> update fires, I can no longer navigate to the next record. It seems to lock
> up. Is there a script that will allow me to continue. Here is the code I
> used on my After Update...

Use BeforeUpdate.

Think about it. You are updating a record in the AfterUpdate event. Guess what? The
event has to fire again now because you made an update. The record is stuck in a
loop.

[Van T. Dinh]

For time stamp and audit trail data, you should use BeforeUpdate Event. I
think you will create a non-terminating loop with AfterUpdate for this
(unless Access picks it up and I have seen cases where my logic was wrong
and Access picked it up).

--
HTH
Van T. Dinh
MVP (Access)



"Jacob" <jacob@intermed1.com> wrote in message
news:Ol1lH#TTDHA.1324@TK2MSFTNGP11.phx.gbl...

> On my After Update on a form. I have it populate 2 fields showing who was

in

> there and what time the changes were made. The problem is, after the after
> update fires, I can no longer navigate to the next record. It seems to

lock

> up. Is there a script that will allow me to continue. Here is the code I
> used on my After Update...
>
>
>
> Me.[Datemo] = Now()
> Me.[Modifiedby] = user
>
>

[Jacob]

You guys rock....Thanks I did not think of it that way and it works just
fine now.



"Jacob" <jacob@intermed1.com> wrote in message
news:Ol1lH%23TTDHA.1324@TK2MSFTNGP11.phx.gbl...

> On my After Update on a form. I have it populate 2 fields showing who was

in

> there and what time the changes were made. The problem is, after the after
> update fires, I can no longer navigate to the next record. It seems to

lock

> up. Is there a script that will allow me to continue. Here is the code I
> used on my After Update...
>
>
>
> Me.[Datemo] = Now()
> Me.[Modifiedby] = user
>
>