Thanks James,

I might be doing the same thing...



>>James,
>>
>>I just tried your suggestion. It didn't work. The value property is 0. Do you know why this happens?
>
>Sorry I don't. For what is worth, I quit using a query data source and stated using an array property as the data source. All those type of problems seemed to go away.
>
>
>
>>
>>>James
>>>
>>>Try setting the displayvalue = value in the init. You should not have to do this but this has worked for me in the past.
>>>
>>>>Thanks for responding Dave. I have tried calling both methods, but nothing seems to work. It displays properly if the boundto is set to .f., but then the incorrect value is saved (the row number, not the data value). This is getting frustrating!
>>>>
>>>>>James,
>>>>>
>>>>>Do you call .Requery() after teh RowSource is set? Do you call thisform.Refresh() as the .ControlSource changes rows?
>>>>>
>>>>>>I'm a bit stumped. I have three comboboxes that are bound to integer fields in a table. The rowsource is a query on a lookup table. The query pulls back a description and an id (integer). The bound column is set to 2, and the boundto property is set to .t. Everything saves the way it's supposed to, but when the form is loaded the values are not displayed. When the user clicks on the control the correct row is selected, but I can't seem to get things to display properly when things are initialized. Any clues? This is probably really simple, but at the moment it's beyond me.