Thanks. I guess those aren't in any of the documentation I've seen. I'll give it a shot.
Thanks again, everyone. Ben -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Gunnar Ekblad Sent: Wednesday, March 30, 2005 1:38 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: WHERE Property in Variable List Box Ben When I had the issue this reply from Larry Lustig put after some trail and errors me on the right track List Table: lstTable List Column: lstField Key Column: kFld Where Clause: LookupWhereClause So, for instance: PROPERTY MyListBox lstTable 'Customer' PROPERTY MyListBox lstField 'FirstName, LastName, PhoneNumber' PROPERTY MyListBox kFld 'CustomerID' SET VAR vWhere = 'WHERE CustStatus = ''Active'' ORDER BY LastName, FirstName' PROPERTY MyListBox LookupWhereClause .vWhere would set up your list box to display customers. Following his adwise you may able to get it working for you to Gunnar Ekblad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Fogt Sent: den 30 mars 2005 06:42 To: RBG7-L Mailing List Subject: [RBG7-L] - WHERE Property in Variable List Box I want to have a variable list box on a form that changes based on other variables on the same form. One way I thought to do this was a use a "Refresh" button that would set a text variable that would be the text string and then use the Property command to set the where clause on the variable list box. It looks like this isn't updateable in Another idea was to assign the where clause to my variable (&vwhere) and use PROPERTY to refresh the list. That doesn't work, either. I think I'll have to use a second form that will contain a scrolling region but I'd rather keep it clean and on a single form. Any suggestions? Ben Fogt
