error with date-field

[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

 

[Arvin Meyer [MVP]]

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.

 

[Jean-Paul]

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

 

[Arvin Meyer [MVP]]

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.