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