You cannot bind combobox to a date field directly. See
How to Bind ComboBox to Date Fields FAQ #8146.
>Am trying to use a cursor as the rowsource for a combobox in a grid. This combobox is bound to a date field in a table. The cursor is a one field cursor (a date field) that consists of 7 records, 7 possible dates for the week.
>
>Instead of having the users type in a date value, i want to let them pick a date from a combobox. Because the validation requires that date to fall within a weekend long period, they would be chosing a date from 7 diff choices. I figure its quicker to chose a date than to type one.....
>
>In the form's init, i create the cursor, drop 7 rows into it, and try to set the combo props:
>
>
>IF USED("tmpdatedetails")
> USE IN tmpdatedetails
>ENDIF
>CREATE CURSOR tmpdatedetails ;
> (cTmpDate D)
>
>*--- add the 7 records here
>
>thisform.grd1.column1.CboDetdate.rowsource = "tmpdatedetails.ctmpdate"
>thisform.grd1.column1.CboDetdate.rowsourcetype = 6
>
>
>
>when the code hits the commands to set the combobox props, it hurls with "Data Type Mismatch". what am i doing wrong?
--sb--