Re: Syntax error in Form

Tech-Archive recommends: Fix windows errors by optimizing your registry

<Sangee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> 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.

Hi Sangee,

It would help everyone here if you would paste your ADD_Click() code in a
post so we can see what you are trying to do.

--
RuralGuy

Please reply to the newsgroup so all may benefit.
.

Quantcast