>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only