If I'm understanding this correctly, you're relying on the native VFP UI to supply the parameter. This is not good; what you need to do is provide the user with a means to enter what they want in your interface and supply that info to the query with a refresh.

>When I set up a SQL parameterized view, by adding ?variablename in the View Designer, I always have to enclose my repsonse in the pop-up text box with single quotes. Is there a way to have FoxPro automatically place the single quotes around the keyed response? I generally can remember to add the single qutoes when I'm entering data but most users are generally confused by this requirement and often forget.
>
>Thanks,
>Robert