How do you add data to two tables at the same time ?
If you could post a sample of your database you might get help sooner. It depends on how you have your tables setup to begin with. But without seeing it there will be much guessing going on. Zip it, Attach It and see what comes your way. Sounds like a relationship problem so far though.
Attached is my DB. I can get the records added to one table and they appear to be added to the second (ie it does pass thru the code) but the records do not appear. Have a look and let me know what questions I need to answer. The problem is on the frmDrawings Complete form.