Hi Nick,

So I am not going to use the ControlSource in this case right ?

Thanks

Veronica

>So, assuming that you are positioned on the right record in your target view
>the combo.Valid should look like:
>
>REPLACE mytargetview.mydatefield WITH CTOD(this.value) IN mytargetview
>
>
>>Hi All,
>>
>>In this case it is a local view(the combo list), and I would like to bind
>>it into a different view.
>>
>>Thanks
>>
>>Veronica
>>
>>>>>How do you ControlSource a date field. I am getting
>>>>>data type is mismatch.
>>>>>
>>>>>Thanks
>>>>>
>>>>>Veronica
>>>>
>>>>Veronica, combo and listbox support only character or numeric data types as controlsource. But you may not use the contolsource property, say you have combo.RowSourceType 3 -SQL Statement and RowSource is:
>>>>
>>>>select dtoc(birth_date) from employee into cursor cdate
>>>>
>>>>Then in combo.Valid you have:
>>>>
>>>>REPLACE sometable.somedate WITH CTOD(this.value)
>>>>
>>>
>>>You may also fill the combobox with DATE data type, but combo.value will be character anyways.