>What did you tell me? Anything I need to know?
>
>When I enter the memvar into the example field I get an error.
Parameterized views are just what you want. It allows you to use a variable to specify the data for the query. In the view designer, enter ?MyVariable. Then select Query > View Parameters from the menu and enter the parameter again and specifiy its data type.
When you run the query, you'll get a dialog box to enter the value for the view parameter. Make a few entries to test the query.
In your program, set the value of the variable (MyVariable) before you do a REQUERY() and you will not get the dialog box.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer