>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...

Mike,

When you requery the combo list, the value the Combo had should not be in the list (because its .Used=.T.). The Combo displays an empty value because its value does not corrispond to any value in the requeried combo list.

If it works with your design, you could set the combo to the first value in combo list after the requery.

Ken