Hi!

Jess, this could help, but one warning - when you do it by such way, the field specified in the ControlSource of the combobox will be marked as changed in the alias (buffered view), that require tableupdate() or tablerevert() to remove this mark.

The best approach to refresh the combobox displaying value after changes in its list (include Requery) is to use just Refresh method call, or use "combobox.ControlSource=combobox.ControlSource".

>>Hi guys!
>>
>>
>>I have a in a form combobox and the rowsource is an alias(teamgroup) created from a remote view. Everytime I edit a record from the form and change the corresponding value of the combobox, I update the table(teamgroup.used)to (.T.)
>>Then I start to requery the remote view(teamgroup). The view has a parameter that will only requery all records with teamgroup.used = .F.)
>>
>>Everytime I requery the table, the expected results should be those with (teamgroup.used = .F.). This exclude the record that I previously edited because I updated its used field to .T.
>>
>>the problem is that initial value of the combobox is not displayed anymore rather, it displays an empty value.
>>
>>any advice or help will be greatly appreciated.
>>
>>Thanks in advance...
>
>After requerying, you should have this line of code: Thisform.combobox.Value = teamgroup.yourdisplayfield then refresh.