checking email input in the form

[letsomebodyknow]

I need some direction. I have a table with a email as a row in a table.

I would like to make sure that the person entering in the data enters the same twice before submitting the data to create the recourd. I know to do this in PHP.

Thanks
Tom

 

[gemma-the-husky]

easiest way is to have two unbound trext boxes., and a real (not visible) text box bound to the field.

on the after update of the each, test that the same data has been entered in both unbound boxes

if it is, set the invisible field, if not clear the invisible field, and prompt for it.

In the form before update event, make sure the hidden email field is set before accepting