SubForm Datasheet row updated event (1 Viewer)

[mfaisal.ce]

Hello,

I have a subform with datasheet view. Now, the problem is how i can find out that New Row added or updated because i want to validate the value of column...

KIndly guide, which event i can use to check for every new record added or updated,????

 

[arnelgp]

you validate it Before the Record is saved.
you can use the "column" BeforeUpdate event or the Form's BeforeUpdate event
to validate the "column".

 

[mfaisal.ce]

you validate it Before the Record is saved.
you can use the "column" BeforeUpdate event or the Form's BeforeUpdate event
to validate the "column".

Subform has only 02 events ( onentry & onexit), there is no other event shown... Basically, i have master child form with child form as datasheet view, so i want to control input or validate the datasheet values on every new row entered......

 

[arnelgp]

you need to Click on the Upper Left Square of the subform in design view to be able to see it.
(after clicking on it it will become Black square).

 

[mfaisal.ce]

you need to Click on the Upper Left Square of the subform in design view to be able to see it.
(after clicking on it it will become Black square).

thanks a lot... it worked

 

[Pat Hartman]

Just FYI,
Form events operate on ONE and ONLY one record at a time and that is the Current Record. You can see which record is "current" if you are showing the record selectors. The record selector will contain a right facing triangle.

 

[Gasman]

Crossposted http://www.vbaexpress.com/forum/sho...-updated-event&p=406146&highlight=#post406146