>>I have a combo box set up as a listbox which is tied to a date field in a table (vitals). I am opening the table and setting the index to date (descending order) and then I am filtering the table in the init event to the dates related to a particular patient id (this is a child table for vital signs which are taken at different dates for different patients)
>>
>>When I run the form, I get the following error:
>>
>>"Error with cmbVitalsDate - Value: Data type mismatch."
>>
>>Any idea why? BTW, I do not have anything in the value property and when I init the combobox, I attempt to load the first date value in the combobox so that it instantiates with the most recent date for the patient displayed.
>>
>>TIA,
>>
>>Bill
>Bill,
>Combo elements have char type. How do you set it init - with dtoc() ?
>Cetin
I tried to have it display its initial value as dtoc(vitals.date) in the init event. The control source is vitals.date with no initial value in the property.
I still get this message.
Is that what you mean?
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!