Combo Box Look up a date

[mattc66 via AccessMonster.com]

I have a combo box on a date field. The combo box looks up data from a
calendar table.

I get a message saying the field is a number field and I am trying to update
it with a text fld or vis-a-versa.

Can you not have a combo box on a date type fld?

 

[Svetlana]

Try convert your data using CDate() function. You many need the
format() function too.