Razzak, Thank you. I knew it was a PROPERTY command! Just had got to the right one yet. I was playing around with PROPERTies for the underlying data, not the form itself.
Jan -----Original Message----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: [email protected] (RBG7-L Mailing List) Date: Thu, 24 Mar 2005 22:41:43 -0500 Subject: [RBG7-L] - Sorting Data in Scrolling Region (was Ref: DB Lookup Listbox) > > At 05:30 PM 3/24/2005, Jan Johansen wrote: > > >Now if sorting the information in a scrolling region was as easy. > >I've been playing around trying to use a bit button to sort the > >region while the form is open. > >Haven't quite found the trick yet.The region is a secondary table. > > Jan, > > Here's how: > > 01. Define the Scrolling Region based on a TEMPORARY table/view > > 02. Define Variable Check Boxes or Radio Buttons to return user > selected sort criteria > > 03. Use the PROPERTY command to first CLOSE the record set > > Example: > PROPERTY <FormTableName> 'CLOSE' > > 04. Re-Define the sorted TEMPORARY Table/View accordingly > > 05. Use the PROPERTY command to OPEN the record set > > Example: > PROPERTY <FormTableName> 'OPEN' > > > For complete details along with source code of two sample applications: > > http://www.razzak.com/sampleapplications (Items 022 and 023) > > Item 022: Universal Data Browser > > Item 023: Universal Data Browser (Part II) > > Enjoy and make sure to have fun! > > Very Best R:egards, > > Razzak. >
