Syntax error in Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.

.

Relevant Pages

  • Re: Syntax error in Form
    ... > I have a form call Job Card. ... > gets added(only for the first time the form is opened). ... > when i enter the values again it is giving me "Syntax error in INSERT ... Whereas when i exit the form and open again it gets ...
    (microsoft.public.access.formscoding)
  • Form needs to be closed everytime
    ... I have a form in which when i enter the values for the first time it is ... enter the values again it is giving me "Syntax error in INSERT INTO ... Whereas when i exit the form and open again it gets inserted. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Syntax error in Form
    ... Private Sub cmdAdd_Click ... Exit Sub ... "RuralGuy" wrote: ... >> gets added(only for the first time the form is opened). ...
    (microsoft.public.access.formscoding)
  • Re: Exiting from python shell
    ... remember a time that I typed the ^D the first time. ... been so awful to just let it be a way to exit when the shell? ... to exit python via a keyword would require also reformulating mathematics as we know it. ...
    (comp.lang.python)
  • Re: Exiting from python shell
    ... remember a time that I typed the ^D the first time. ... been so awful to just let it be a way to exit when the shell? ... to exit python via a keyword would require also reformulating mathematics as we know it. ...
    (comp.lang.python)