1) Don't use TRANSFORM, changes to text
2) Make sure variables as referenced stay in scope
Bob
>I get a datatype mismatch on the SET FILTER command. TransDt is a date. I'm sure this isn't the way to do this, so any help appreciated.
>
>THISFORM.FilterCondition = THISFORM.FilterCondition + ' AND BETWEEN(TRANSFORM(TransDt),' + TRANSFORM(THISFORM.TransDtBegin) + ',' + TRANSFORM(THISFORM.TransDtEnd) + ')'
>m.FilterCondition = THISFORM.FilterCondition
>SET FILTER TO &FilterCondition
>
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'