Assuming TransactionDate is a Date-type field, you need to enclose the date
in # characters (or else use the CDate function)
.Fields("TransactionDate") = Format(Me.txtTransactionDate,
"\#mm\/dd\/yyyy\#;;;\N\u\l\l")
or
.Fields("TransactionDate") = CDate(Me.txtTransactionDate)
(See
http://www.mvps.org/access/datetime/date0005.htm at "The Access Web"
for other formats to use if TransactionDate contains time as well as the
date)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Jan Il" wrote in message
...
Hi Andi :-)
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
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.
Thank you.
Jan
If you expect an answer to a personal mail, add the word "manfred" to
the
first 10 lines in the message
MW