Syntax error in Form

Hi,

I have a form call Job Card.

When I open the form and enter the values and click the add button, it gets
added(only for the first time the form is opened).

When I enter the values again without exiting the form, it is giving me an
error "Syntax error in INSERT INTO statement". Whereas, when I exit the form
and enter the values, it gets inserted without any error.

So each and every time I insert a record I need to close the form and open
it again.

Can anyone help me how to solve this issue.

Thanks.

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.

.

Loading