N Neo Registered User. Local time Today, 22:26 Joined Mar 5, 2003 Messages 42 May 30, 2003 #1 To find all records that begin wih a a certain Number do I use this dim rst as recordset set rst = Me.recordsetClone rst.findfirst "EmpNo = " & seach *
To find all records that begin wih a a certain Number do I use this dim rst as recordset set rst = Me.recordsetClone rst.findfirst "EmpNo = " & seach *
Mile-O Back once again... Local time Today, 22:26 Joined Dec 10, 2002 Messages 11,305 May 30, 2003 #2 rst.findfirst "EmpNo Like " & seach & "*" provided that EmpNo is a text field.