Insertion into 2 tables from 1

[yessir]

I have the following db and form on my computer. I have checks and sql in the code to try the insertion but it simply throws a error.


The code is at the bottom of the main form. if you open and run it it will throw the error for you.

I REALLY need help on this, I have been trying for day....

Thanks in advance!

~

 

[maxmangion]

the first thing you should consider is to base your form on a query rather than on sql statements in the record source

 

[yessir]

I am using recordsets though,

so that I can deal with one record at a time rather than all at once.

I am ONLY using sql to insert.


Anything else?

as to y it isn't working?