(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 yours in just 2 easy steps! (http://pr.atwola.com/promoclk/100000075x1215855013x1201028747/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072%26hmpgID=62%26bcd=De cemailfooterNO62)
