error with date-field

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

Jean-Paul

Hi,
I have following code:

tb!datum = Me!Datum_opdracht

tb!datum is a date field in a recordset
Me!datum_opdracht is en entryfield on a form

I get an errormessage saying (have to translate from dutch message)

Error with conversion of datatype...

What am I doing wrong?

Thanks
 
If you see error number 13 with your error message, it would confirm that it
is a "type mismatch" which means that you have tried to join 2 different
datatypes, or that your code was expecting 1 data type, and you have fed it
a different one. Example:

CInt("Jean-Paul")

Jean-Paul is text and cannot be converted to an integer.
 
tb!datum is a date field in a recordset
Me!datum_opdracht is en entryfield on a form

I don't see any difference in data type???
I did not decalre datum_opdracht so....

Strange
 
In English "Date" is a reserved word, and may be in your language as well.
Datum in English may also be reserved since it is the singular of data.
 
Back
Top