SEEK

Searched for a specific value in a field, and positions the recordset on the matching record. SEEK(Subform // FieldName // Operator // Value) PARAMETERS Subform 0 or blank = Main Form Datasource 1 = Subform#1 2 = Subform#2 3 = Subform#3 4 = Subform#4 5 = Subform#5. Fieldname The name of the ‘field’ which you want to search in. Operator The operator of an expression (ie.  In the expression FIELD1 <> FIELD2,  <>  is the operator. =  Equality < Less than > Greather than <= Less than or equal to >= Greater than or equal to <> Not equal Value The value to search for. To position the SUBFORM#1’s datasource on the record where CustomerName = ‘JOE’: SEEK(1//”CustomerName”//=//"JOE")