>I've got a form based on cBizObjModalForm. I've got a listbox on the left hand side. On the right hand side there are 15 textboxes (cTextboxl). When the user clicks on an entry on the list box, the text boxs on the right are updated. In the Click() method I've got the following code:
>
>LOCATE FOR v_Standings = THIS.Value && THIS.Value has the cID of entry.
>THISFORM.Refresh()
>
>(I tried using the LockScreen property but didn't notice a difference).
>
> There is a 1.5-2.5 second delay from when I click on a entry until when the new values appear. I created 3 indexes on the view in adataenv.prg:
>
>
>lcIndexExpr = 'INDEX ON DELETED() TAG deleted'
>This.....
>lcIndexExpr = 'INDEX ON PRODSTATUS TAG Prodstatus'
>This.....
>lcIndexExpr = 'INDEX ON cID TAG cID'
>
>None of this has helped the speed at all. The v_Standings view probably has less than 100 records (and 90 of them are deleted). Any suggestions to optimize this screen?

Why don't you use SEEK ? You will only need to index the view on cID...

seek this.value

BOb