>>Hi All,
>>
>>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