Marcia,

I'd like to say this works but......

I created the view as you mentioned at added the filters for the two id's. Then on the form, I added the view to
the DE and dropped the view on the form (as a grid). When I execute the form, I get prompted manually for the
two vp's. These values are to be "controlled" by the two combo drop down lists on the form. Now what?

p.s. I am reposting the help question with all the table/field names and exactly what I am trying to do in case
I lost you as I have lost myself!!! <grin>

>Hi Peter.
>
>>> OK, this makes sense - sort of.... I may be a bit nieve but... If I use the View tools to create the view, how do
>I control what records go INTO the view. They can change constantly when the user picks a different event
>or bar from the drop down lists. The view needs to be updated at runtime. <<
>
>PMFJI, but in this case you need a parameterized view. To set the view paramter in the view designer, under the filter tab, select the correct field from the drop down list on the left and type in the name of the paramter in the box on the right like this:
>
>?vp_value
>
>You need the '?' immediately in front of the variable name with no spaces between the '?' and the variable name.
>
>The, in your form, when you want to change the information displayed in the grid, you use code like this:
>
>vp_value = < some value >
>REQUERY( 'MyView' )
>
>One thing to watch out for: make sure that you have either reverted or commited any pending changes in the view before you requery it or you will get a VFP error.
>
>HTH.
>
>Marcia