Value isn't valid for the field

[StuckfromPR]

I have a query that returns a list of the months that are present in a table. The month's properties is Date/Time, with a format of mmmm, so the month appears as a word not a number (i.e. November instead of 11/11/2008)

I need for the users to select a month within that list of values. I created a Combo Box (drop down) with that list from the query. But Every time I select the month the following message appears.

The value you entered isn't valid for this field.

What am I dong wrong? Thanks,

 

[missinglinq]

What action is taking place after the month is selected? Using the Format() function returns a string, not a Date. Whatever the "month" selected is being used for apparently requires a Datatype other than Text.