>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.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."