You cannot bind combobox to a date field directly. See How to Bind ComboBox to Date Fields FAQ #8146.

>I have a combo box with a control source which is a date field in a table.
>The row source is a cursor that looks like:

>Field 1      Field 2
>--------     --------
>Jan. '03     01/01/03
>Feb. '03     02/01/06
>Mar. '06     03/01/03
>...

>Bound column = 2
>
>I get a data type mismatch.
>I've tried;
>setting format to D - not accepted
>setting Value to =date() - data type mismatch
>In the Init - This.Value = date() - data type mismatch
>
>I need to store the result to a date field. Can anyone help?