I got a add form with a txtbox for code which is the primary key for the table.
How do i validate for duplicates in the valid event of the txtbox . the data-source property is set to table.code_field

I want the record adde only if the user presses save otherwise no
i also want the fields blank when i pop up the form ..

What do i do ?

Hiten K M