Hi Andi :-)

have you missed that?

the error is he
your table needs the TransactionDate set to a Value,
because addnew adds this field with a Null Value

.Fields("TransactionDate") = me.TransactionDate

Ahhh...yes....I scanned down too far and did miss this part of your reply.
Sorry.... ;o)

Thank you for your time and assistance, I really appreciate it. :-)

Jan
Smiles are meant to be shared,
that's why they're so contagious.