>I’ have a combobox in a form with the next properties:
>
>BoundColumn: 2
>ControlSource: repvesp.iIDArea
>RowSource: area.Nombre, iID
>RowSourceType: 6
>
>Since the data is to be displayed in alphabetical order by name (nombre), the table “area” is ordered by the first column “Nombre” (tag Nombre) which is a field of type character, by setting the “order” property to NOMBRE into the form’s dataenvironment.
>
>Problem: Instead of replacing iID into repvesp.iIDArea, the value being replaced is its position as shown by the combobox (First element shown replaces 1, second 2, etc., though their iID’s are other values).
>
>I’ve tried a local view with no tags involved and the same thing happens.
>
>This does not happening when there is no order selected for the table.
>
>Please, if anybody knows a way around this let me know.
>
>Regards
If repvesp.iIDArea is integer, then you should reset Combo.BoundTo property.
Edward Pikman
Independent Consultant