>Hi John,
>>Does the question mark only work on 5 and above?
>
>Works in VFP 3 too.

Dang it, I'll have to try it again... It didn't work the first time I tried it..

Thanks
and your SQL looks like WHERE State = ?vpState. The view parameter is simply a variable. When the query runs, if vpState does not exist, a window will pop up asking for a value. If vpState exists, then it will be used.