Sometimes you have to refresh the grid explicitly (i.e. THISFORM.MyGrid.Refresh) in order for it display correctly. I have also heard others having to actually SetFocus to the grid to get it to refresh.
HTH.
>Hi all:
>I have a parametrized view named VIWINV. This view takes a variable (varCode) to filter records (CodeNo=varCode). I have the variable established in the Query/ViewParameters Dialog box, and set in the view designer as ?varCode. I have a form with a grid based on this view. I want the parameter passed by means of selecting a code number from a Combo box. I have the following code in the Interactive Change event of the CBox:
>
>public varCode as character
>store this.value to varCode
>requery(viwinv)
>thisform.refresh
>return
>
>but the grid doesn't change to show the . What am I missing?
>TIA
>Ulises
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao