two separate insert statements - only one works

[leah f via AccessMonster.com]

I have a loop. For each record I perform two checks.
For each error I want to write a record in an error table. If two checks
fail, I want to write two records.

Code in the loop: mystring = "......"
db.execute (mystring)
mystring = "......"
db.execute (mystring)

If there are two errors, only the first record will be added. If I
"comment" the first record, then the second will be written so it is not a
problem of the sql statement.

Any suggestions?

 

[leah f via AccessMonster.com]

Problem solved.