L
Lori
Hi,
I have a form with a subform. When a record is added, or even updated,
on the subform, I want to validate the contents of a couple of the
fields. I put validation logic in the subform's BeforeUpdate event. I
expected that this event would be triggered once the data is entered
and is about to be saved.
I was suprised to see the event getting triggered before the
form/subform has even been displayed, during the process of
opening/loading/populating the forms (I set a breakpoint, and it's
getting triggered somewhere after the open and load). Why is this
happening? Is the data getting moved from the table to the form's text
fields triggering an update event?
How can I validate my data before the records are saved on the table?
Thanks in advance for any help!
Lori
I have a form with a subform. When a record is added, or even updated,
on the subform, I want to validate the contents of a couple of the
fields. I put validation logic in the subform's BeforeUpdate event. I
expected that this event would be triggered once the data is entered
and is about to be saved.
I was suprised to see the event getting triggered before the
form/subform has even been displayed, during the process of
opening/loading/populating the forms (I set a breakpoint, and it's
getting triggered somewhere after the open and load). Why is this
happening? Is the data getting moved from the table to the form's text
fields triggering an update event?
How can I validate my data before the records are saved on the table?
Thanks in advance for any help!
Lori