On leaving a Row in the Datasheet

  • Thread starter Roshan Abbasi via AccessMonster.com
  • 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.
 
R

Rick Brandt

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.
 
R

Roshan Abbasi via AccessMonster.com

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!
 
R

Roshan Abbasi via AccessMonster.com

I had overlooked that. Thank you very much Rick Brandt.
 
Top