Hi Ulises,
Sounds like a scope issue. How is varCode defined *before* the InterActiveChange can fire? Try changing the varcode parameter to a Form property and change the view to ?ThisForm.varCode (change the InteractiveChange code as well).
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05