>>>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?
Do you put directly to .value property ? and controlsource = "vitals.date" which is date type ? If rowsourcetype is set to fields than just seek() corresponding date, if not then put something like this in init :
for ix=1 to this.listcount
if this.list(ix,2) = dtoc(yourdatevaluehere)
this.listindex = ix
exit
endif
endfor
Cetin