On Wed, 22 Dec 2004 14:00:54 -0500, "Jan Il"
wrote:

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


.Update

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW