>>>>>I have a combobox on grid with
>>>>>
>>>>>Column.Sparse = .f.
>>>>>BoundColumn = 1
>>>>>BoundTo = .f.
>>>>>RowSourceType = Array
>>>>>
>>>>>Depending on value of another column of the grid the array of the combobox is loaded with different SQL, but always appear a phanton record (blank record) in the combobox.
>>>>>
>>>>>What am I doing wrong?
>>>>
>>>>Do you mean that combo.rowsource should be different for each record?
>>>
>>>The combo.rowsource is always with same name of the array.
>>>
>>>The contents of the array can be different for each record of the grid.
>>>
>>>This phanton record disappears after I choose one vale on combobox.
>>
>>In general, you cannot have different array contents for every record. How many records you have?
>
>The array has 20 records in the maximum on each case (3 differents). The grid is empty I am inserting records on it.
If I understand you correctly you may have 3 different rowsources. In this case you may add 3 comboboxes (with fixed source) to the column and use DynamicCurrentControl property to show correct box for every record.
Edward Pikman
Independent Consultant