>>>I have a combobox on a form that is bound to a Fiscal Year End column from a view. My problem is that I get a "combobox value-Data Type Mismatch-unbinding object combobox" error whenever I try to run the form. I understand that the combobox value property returns character strings and that's probably why it won't work, but, since this is a date field, is there any way around this?
>>>
>>>Thanks for the help! (In case you couldn't tell, I'm new to VFP :)
>>>
>>>Amanda
>>
>>do you really need to bind the column to the date field? If your RowSource is a cursor or table, the selected item will be pointing to the cursor record. You can get the value directly from the cursor.
>>
>>Bill
>
>Hi! Thanks for the reply. Yes, we need this combobox to have the controlsource of the field. When the user changes FYE via this combobox, it changes all the information in the rest of the form to reflect that FYE's info. Does that make sense? If I can get past the error, it seems to work just fine. But, obviously, I don't want the error in at run time for users.
>
>Any more ideas? Thanks for your help!
>
>Amanda

Why don't you still unbind it, then programmatically test in the InteractiveChange and ProgrammaticChange events to make necessary display changes based on the record the combo is pointing to?

Bill