Thanks bme2005, I just posted my thread out there. Hopefully,I'will get my solution back soon. BTW, if i take out the error handiling, it inserts it into both the table eventhough the input value dept is already in dept table. It should insert only in auditdept table. Thanks in advance to everybody who can input some thoughts.