On Wed, 22 Dec 2004 16:13:01 -0500, "Jan Il"
wrote:

I added the above to the existing code in the Transaction control NotInList
event code, in the area where it appears it should go, and I am now getting
a type mismatch error: Here is what I added and where in the code:

With rst
.AddNew
.Fields("Transaction") = NewData
.Fields("TransactionDate") = Me.txtTransactionDate
.Update

The txtTransactionDate is the name of the control on the form. It does
compile alright, but, when I click OK on the Add box, the error message is
fired. Sorry to be so dense, but, obviously I'm not doing it right.


I don't know which Type .Fields("TransactionDate") is and which Type
the Form Field Me.txtTransactionDate is, but both have to match.



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