>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.