Diane,
One technique I've used is to base (in my case) the scrolling region on a view. In the code that would do the jump to I would: PROPERTY TABLE viewname 'CLOSE' DROP VIEW viewname - Redefine the view here PROPERTY TABLE viewname 'OPEN' In the view redefinition you would have "WHERE DocNo = thedocnotodisplay The only problem here is that the result is not scrollable - the view will contain only one document. But, you could have another button to restore the full recordset . Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, January 30, 2009 3:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Searching on a Column in a Form (Oops, the e-mail got sent before I signed it!! Here it is again...) Hi, all, I have a form based on a table having about 25,000 records with a key field called "DocNo". The form has several subtables on it. On the form, I have the normal navigation bar; I also have a button "Jump to Rec#" that uses "PROPERTY TABLE <tablename> <record no. to jump to>" to jump to a particular record# in the recordset. This button works well. I also have a button "Jump to Doc#" where I'd like the user to be able to enter the "DocNo" value, and the form would skip to the record whose "DocNo" field has the value specified by the user. I've tried the command: PROPERTY TABLE 'FormTableName->SEARCH->FormColumnName->' varname where "varname" is the DocNo specified by the user. This command will ultimately find the record, but the form is repainted for each record along the way and it takes seconds or minutes to arrive at the specified record. I've tried using PROPERTY RBASE_FORM alphablendvalue "0" and PROPERTY RBASE_FORM alphablendvalue "255" to hide the form until the record is found (and then display the form), but it still can take forever to arrive at the selected record, and the screen periodically blinks during the processing. Does anyone have any ideas as to how I can do a search on a column in the recordset that the form is based on, and 1) have it be quick and 2) not have the screen repainted over and over again through the recordset while the column is being searched? Thanks, Diane DeMers [email protected] DeKalb, IL _____ A Good Credit Score is 700 or Above. See <http://pr.atwola.com/promoclk/100000075x1215855013x1201028747/aol?redir=htt p://www.freecreditreport.com/pm/default.aspx?sc=668072%26hmpgID=62%26bcd=Dec emailfooterNO62> yours in just 2 easy steps!
