Hi Cetin.

Thanks for another approcah !!

regards,

Gerard


>>Hi.
>>I'm using a file in a form and i need to set a filter on the file, which will be recognized across screens.
>>
>>My command is something like:
>>
>>Sele MyFile
>>Set filter to Myfile.Myfield = Thisform.MyFilterValue
>> (Say thisform.MyFilterValue = 100)
>>
>>Now wen I call up a sub form, it kicks up because it cannot see Thisform.MyfilterValue (as its on the calling form !!)
>>
>>I want the set filter to read the absolute value i.e.
>>? Set('Filter') to = ---> Myfile.Myfield = 100
>> and not
>>Myfile.Myfield = Thiform.MyfilterValue
>>
>>regards,
>>
>>Gerard
>
>Gerard,
>As an addition to what Sergey said for such expressions you could also use :
>set key to thisform.MyFilterValue
>provided table's active index key is myField. It's evaluated once at the start.
>Cetin