Solved Saving procedure in datasheet form

[Kayleigh]

Hi,
I have a datasheet form for data entry purposes only. I would like to validate the data user inputs once a record is input but before creating a new record. Have tried several events but couldn't achieve desired outcome.

BeforeInsert/BeforeUpdate fires for every new field entered - I would just like to run once the record is filled in.
Current runs as soon as the form opens when no data is even input and also it is referring to the record is has moved onto.

What's best way to do this please?

 

[theDBguy]

Have you tried using the Form's BeforeUpdate event? That should only fire once.

 

[Kayleigh]

Thank you managed to work it out.

 

[theDBguy]

Thank you managed to work it out.

Good luck with your project.