Thanks Wayne.
Regards,
Gerard
>
lcFilter = [Myfield = ] + TRANSFORM(Thisform.MyFilterValue)
>Select MyFile
>Set filter to &lcFilter
>
>>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