Form needs to be closed everytime

S

Sangee

Hi,

I have a form in which when i enter the values for the first time it is
opened, and click the ADD button it gets inserted into the table but when i
enter the values again it is giving me "Syntax error in INSERT INTO
statement". Whereas when i exit the form and open again it gets inserted. So,
every time i add the record, i need to exit and open the form again to insert
another record. Can anyone help me with this issue?

Thanks.
 
Top