>>>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
>
>
>OK, I did what Ed suggested, deleted the controlsource property and left the row source as dtoc(vitals.date). What I can't seem to do is get the first element in the list to display in the box when it inits. I set the displayvalue to dtoc(vitals.date) and the value to the same and refresh. All other fields of the same record are popping up on the form. Don't understand this one either.
>
>It's not critical for this to display. Would look a lot nicer though. Any thoughts?
I suggested somewhat different. Just put your combo, via builder set controlsource to vital.date, boundcolumn to vital.date. If using with rowsourcetype = alias then you don't need to set value on init. Just seek to desired rec. In ýnteractivechange add thisform.refresh, when rowsourcetype = alias then rec pointer moves with combo movement and I think what you want is that.
Cetin