On current event not starting (1 Viewer)

[StefanSch]

I have a question regarding the on current event of a subform.

My subform has 5 fields. Each field has an after update event, something like this (shortened):

Begin code
.....
....
me.dirty = false
Me.requery
....
.....
End code

When the after update event of a field is finished I would like to start the on current event of the subform. However, I am not getting this to work. The on current event of the subform only starts when I move to another record.

Any ideas?

 

[Rich]

Call Form_Current in the AfterUpdate event of whichever textbox you want the event to fire

 

[StefanSch]

Thanks. I will try this.

Hopefully the effect of the "me.requery" will take effect before the on current event is started. Otherwise the on current event is useless.

With "me.dirty = false / me.requery", a text box (let's say text box A) in another subform must be updated with the entered data in the text box with the AfterUpdateEvent. The on current event refers to the value in text box A (value after the me.dirty/me.requery).

I will inform you if it works. I will be able to try later only.

 

[Rich]

I don't understand why you need Me.Requery, if your code is in the form current event

 

[Rich]

It's been ongoing on several threads now Pat