December 23rd, 2004, 02:01 PM
|
|
Hi Andi :-)
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.
The .Fields("TransactionDate") is mm/dd/yyyy hh:nn" P"
the form field txtTransactionDate is the same
Jan
|