>Hello There,
>
>This is what I'm trying to do, and I think it's possible:
>
>I have a drop-down list box that contains a list of stores with their associated StoreId's. I want to create a grid(using a view) on my form that displays all the items a particular store has. I have two tables. StoreItems and Items that are linked via an ItemId. What I need to do is on the InteractiveChange event of my drop-down, refresh the grid with the correct store items by passing the view the StoreId. I can't seem to figure out how to do that.
>
Jim,
Assuming the name of the combo is Combo1 you would, in the combo's InteractiveChange;
THISFORM.Grid1.Refresh()
In the grid's refresh you would;
lcParm = THISFORM.Combo1.Value
REQUERY("
")