Kayleigh
Member
- Local time
- Today, 01:57
- Joined
- Sep 24, 2020
- Messages
- 706
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?
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?