|
I agree with David, this is the single most useful form in the sample databases....and I use it as the basis of a lot of functions. I've also adopted it to search for rows based on a "contains" criteria, for those data fields where the user might not know the exact name or the first few letters. Works great either way.
Paula
-------Original Message-------
Date: 08/03/04 09:01:42
Subject: [RBG7-L] - Re: Another Combo Box Question.
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.
----- Original Message -----
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.
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.
| 
