Continuous Form. Exit row event?

[Cameo]

Any way to tell when a ROW on a continuous form has been exited? I ask because the underlying record source table does not get updated until the ROW is exited. I then want to refresh after the physical table is updated.
Hope this makes sense. Thanks.

 

[pbaldy]

If data was changed, the form's update events will fire. The current event will fire no matter what. Since it sounds like you want to do something after the data is updated, perhaps the after update event?

 

[Cameo]

I want to know when the physical data table is updated-which doesn't happen until the user leaves the ROW. It doesn't happen when the user leaves the field on the row. I think I can use the AfterInsert and OnCurrent events. Will be a bit messy, though.

 

[Rich]

If Me.Dirty Then
RunCmd, SaveRecord

 

[SOS]

The form's AFTER UPDATE event is what you want.

 

[Cameo]

SOS, Exactly what I needed! Perfect. Thanks.

Something to note, however, deleting a row does NOT fire off the form AfterUpdate event.

 

[pbaldy]

perhaps the after update event?

I guess I should have used all caps?

 

[SOS]

I guess I should have used all caps?

Maybe just needed more force behind it, instead of the "perhaps..."

 

[Cameo]

Sorry, pbaldy. You did give the needed answer. Caps on the event names would have helped guide me to check out the specific answer. I'm just beginning to be familiar with them. Thanks, too.

 

[gemma-the-husky]

deleting fires a delete event,(and possibly a before del confirm, and a after del confirm) then a current event, if there is still a row to be current

its amazing how many events there are , all with their own nuances

----------------
but there isnt an exit row event

the beforeupdate/afterupdate fire for theform, if data has changed, then the current event

if no data changes, there is only a current event.

the only way you could force an update is deliberately use code in the current event to dirty a record - then there would HAVE to be a before/after update pair.