>>For example, I want my user to select a state (Florida). The grid (bound to a view) would show only items with Florida. Now when the user selects Nevada, The grid shows only Nevada items.
>>
>>Sounds simple but I could use any pointers to make this transaction clear. I have success with a query that's hard-coded with "Florida". I am missing how to assign a variable to the query so that it refreshes when the user leaves the prompting box.
>>
>>p.s.I posted this under Code & Commands but I didn't see it displayed, (after 30 minutes). This is my first call for help on the VFUG.
>
>After setting up your VIEW, using a filter based upon a PUBLIC variable (CStateName), set that variable to the user selected state in your application, and REQUERY("ViewName"). After your form is refreshed, you'll see only records that meet your filter criteria.
>
>If someone knows a faster way, please pass it on......
>
>Michael

Thank you, Your idea worked. It works fast enough for my tables.