>>You don't need that code. See the bound property of the combo box to the >>corresponding field. This should refresh automatically as the other >>fields are being refreshed.
>The field is character. The click event for the combobox sets a filter >and order in a child file then refreshes the form.
>The properties in the Data tab for the combobox are as follows:
> BoundColumn=2
> DisplayValue=1
> FirstElement=1
> NumberofElements=0
> RowSource=Csddist.OrgName, distdlrid
> RowSourceType=6-fields
The BoundColumn determines which column of your combo is displayed in DisplayValue. If you want to show the OrgName you'll need to set the Bound Column to 1. If distdlrid is an Interger/Non-Character you're going to have problems because they cannot be displayed in a combo, VFP automatically converts them to characters.
The ControlSource and the BoundColumn should be set to the same field otherwise you'll overwrite the ControlSource with the value coming out of the BoundColumn.
Which fields are you displaying and which are you trying to return/change?
----------------------
Grant Floyd
Phil Radford Consultants
email:
floydg@radcomp.co.nzphone (07) 5784576