Hiya JimB,
Simple case of the afternoon "stupids" .. thanks for you and Fred pointing that out :-D
>>
>>All variables are Local by default; once your program moves beyond Init, the filter can no longer be evaluated. I like Dan's idea of a parameterized view based on a Form property, but be careful to set NoDataOnLoad to .T. and REQUERY() the view in the Form Init.
>
>
>John,
>
>Minor correction: all vars are PRIVATE by default. LOCALS msut be declared as such.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05