[RBG7-L] - Re: Another Combo Box Question.

[David M. Blocker]

See also Razzak's SearchForm in several of the RRBYW samples.   It's easy to set up and permits the user to enter 1 or more letters of the start of the value searcing for, press Tab and a list box is populated instantly with all records meeting the critiria. I've adopted it as my standard and at the conference presented a way to create ONE for and ONE eep that serve many tables.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Charles Parks To: RBG7-L Mailing List Sent: Monday, August 02, 2004 6:24 PM Subject: [RBG7-L] - Re: Another Combo Box Question. Upon opening a form use "Edit using formname..." with no where clause.  The where clause will have to be inside of the temp view since the form's where clause cannot change but the temp view's where clause can change upon recreation. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Posted At: Monday, August 02, 2004 4:16 PM Posted To: RB7-L Conversation: [RBG7-L] - Re: Another Combo Box Question. Subject: [RBG7-L] - Re: Another Combo Box Question. I haven't looked at this form in ages (done in original 7.0, before we even had properties), but this merits a re-check!  I'm going to try your solution! Karen For shortcut in navigating through a thousand records with having the form based on a view (tvTest) Place a variable on the form called vWhere and then have a button with this eep DROP VIEW tvTest CREATE TEMP VIEW tvTest AS SELECT column from table WHERE &vWhere PROPERTY TABLE tvTest 'REFRESH' It allows for changing the where clause without closing the form.