> edit using &vWhere > Then at the click of a button > Property TABLE TableName 'CLOSE' > Set var vWhere = 'Where somevalue = '''SomeOtherValue'''' > Property TABLE TableName 'OPEN' > Property TABLE TableName 'REFRESH' > > and the Recordset changes to the new where condition.... > > C'mon, can I have it? Please... Please.. Can I??
I like what you're thinking! (Although I'm not sure that exact syntax would work, since R:Base would have forgotten the special meaning of vWhere after the macro substitution.) For the sake of completeness, how about: -- To change the underlying where clause and sort order of the form's recordset PROPERTY RBASE_FORM WhereClause 'WHERE ya ya ORDER BY ya ya' -- To filter the current recordset PROPERTY RBASE_FORM Filter 'WHERE ya ya' -- To move to the first matching record in the recordset PROPERTY RBASE_FORM GoFirst 'WHERE ya ya' -- To move to the next matching record in the recordset PROPERTY RBASE_FORM GoNext 'WHERE ya ya' -- To move to the previous matching record in the recordset PROPERTY RBASE_FORM GoPrevious 'WHERE ya ya' -- Larry
