>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
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site