wild cards

Neo

Registered User.
Local time
Today, 22:26
Joined
Mar 5, 2003
Messages
42
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 *
 
rst.findfirst "EmpNo Like " & seach & "*"

provided that EmpNo is a text field.
 

Users who are viewing this thread

Back
Top Bottom