>>>I have several comboboxes in a page on my form. Sometimes, the value shown doesn't reflect what I have in my views. All my comboboxes are bound from my view. I don't know what's happening.
>>>I use Optimistic row buffering for my view and all the comboboxes use 6- Field for recordsource.
>>Sonny,
>>Rowsource=Fields means that any change in combo would move recpointer in view and the reverse. Might it be that.
>>Cetin
>
>Hi, Thanks for the reply, I'm not sure if I'm following you but the record source for the combobox is based on a table. And the controlSource for the same combobox is a remote view using SQL Server 6.5
Sonny,
You said you have several comboboxes each with Rowsourcetype=Fields . Right ? And all use fields from the same view.
Say a combo has props:
RowsourceType = 6
Rowsource = "myview.field1, field6" && Lookup also in same view
ControlSource = "myview.field6"
When combo drops and you navigate you do the navigation in view too. You might not notice the movement till a refresh.
Cetin