On leaving a Row in the Datasheet

  • Thread starter Thread starter Roshan Abbasi via AccessMonster.com
  • Start date Start date
R

Roshan Abbasi via AccessMonster.com

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.
 
Roshan said:
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.
Click to expand...

If this is a datasheet *form* then you can use the Current event, but that fires
"as you arrive" not "before you leave" a record. If it is a table or query
datasheet then you cannot do this as they do not have events.
 
Thanks Rick Brandt for the response.
My Datasheet is on a Subform and I could not find the 'Current' event of this
object - either from the Parent form or from within the Subform. Would you
kinly elaborate more on this, please!
 
Roshan said:
Thanks Rick Brandt for the response.
My Datasheet is on a Subform and I could not find the 'Current' event
of this object - either from the Parent form or from within the
Subform. Would you kinly elaborate more on this, please!
Click to expand...

Open the form that is the source object of the subform in design view. The
current event is the first one listed on the { Events } tab of the property
sheet.
 
Back
Top