On current event not starting

[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

 

[Pat Hartman]

If you are intending to save the current record, why hide that intention with the cryptic -
me.dirty = false

It is ALWAYS best to the non-cryptic method -
DoCmd.RunCommand acCmdSaveRecord

Your logic seems convoluted. Are you trying to "push" a value entered on the main form to some field on the subform? You might get better help if you gave us an overview.

 

[Rich]

It's been ongoing on several threads now Pat