After_update problem

L

lana

Registered User.

Local time

Today, 09:04

Joined

Feb 10, 2010

Messages

92

• Jun 21, 2018

• #1

Hi there,


I would appreciate if someone could help me with this problem.


I have a sub-form on a form. In this sub form data must be entered.

I need to execute a code when each record is entered in the sub-form.


I wrote the code in the "After_Update" procedure of this sub-form.


BUT ---- it doesn't run . When I include a toggle (break point) in a line , then this procedure is executed correctly.????


Help is desperately needed, PLEASE.



Thanks

 

Minty

AWF VIP

Local time

Today, 05:34

Joined

Jul 26, 2013

Messages

10,706

• Jun 21, 2018

• #2

What's the code, and what's the purpose ?

 

L

lana

Registered User.

Local time

Today, 09:04

Joined

Feb 10, 2010

Messages

92

• Jun 21, 2018

• #3

The code does not matter. Whatever the code is, it doesn't go to the "After_Update" procedure.

The purpose is : when a line of record is entered, some fields must be updated in another table. The code works fine but works only when I add a break point and run it line by line.
Thanks

 

Minty

AWF VIP

Local time

Today, 05:34

Joined

Jul 26, 2013

Messages

10,706

• Jun 21, 2018

• #4

I suspect the code does matter, as it doesn't work as you expect.

Normally validation or triggered events are fired / checked in the BeforeUpdate event, as this is called before a record is saved.

The after update event on a record level is not terribly reliable from memory, you might be better to check if the record is dirty?

 

Minty

AWF VIP

Local time

Today, 05:34

Joined

Jul 26, 2013

Messages

10,706

• Jun 21, 2018

• #5

In addition to Pat's comments, I believe the Forms after update event will fire after any field is updated, you really need a complete record update to be processed I assume.

 

L

lana

Registered User.

Local time

Today, 09:04

Joined

Feb 10, 2010

Messages

92

• Jun 22, 2018

• #6

Thank you all.

I solved the problem with Me.refresh and also I changed the code procedure to a specific field "lost focus".
It works like a charm.
Cheers

 

B

Beetle

Duly Registered Boozer

Local time

Yesterday, 22:34

Joined

Apr 30, 2011

Messages

1,807

• Jun 22, 2018

• #7

lana said:

Thank you all.

I solved the problem with Me.refresh and also I changed the code procedure to a specific field "lost focus".
It works like a charm.
Cheers

Click to expand...

So now the code will fire every time a user tabs through that control, whether they updated the record or not. Are you sure that's what you want?