On leaving a Row in Datasheet

[raabbasi]

I have a Datasheet bound to a table. I want to update records in another table, each time when the user leaves a Row (a record) of the Datasheet and enters into another row.

 

[RoyVidar]

I don't think there's any reliable "on leaving a record" event, unless you're also updating the record, then the after insert would work for new records, and after update for all records having a change.

The on current event will fire whenever you navigate between records (i e, when "arriving" on the next record, be it a new one or existing one).

Roy-Vidar

 

[RoyVidar]

Oh - and since this is a forms question, not a Modules/VBA coding question, the form forum is perhaps more appropriate (forum702)

Roy-Vidar

 

[raabbasi]

Thanks Roy-Vidar for the response. My question is about Coding the Datasheet in VBA.
I could not find the "OnCurrent" event, or I have mis-understood.
I would appreciate if you elaborate on;
"The on current event will fire whenever you navigate between records (i e, when "arriving" on the next record, be it a new one or existing one)."

Thanks.

 

[RoyVidar]

Only "programmable" thing called Datasheet, is the datasheet view of a form -> standard forms coding -> forms forum (forum702). The form has several events, among those, the on current event. Found in the design view of the form, property dialog, event tab.

Roy-Vidar

 

[raabbasi]

I got it. Thanks again.
Regards.