Good advice, Gunnar! Wink! David
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, March 30, 2005 1:38 AM 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 > > --- RBG7-L > ================================================ > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > ================================================ > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > ================================================ > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > ================================================ > >
