No, you are not.
>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.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison