Hi, I am using the code below and two things are not ok.
Firstly the form freezes after finding the correct name and
the Like argument doesn't find anything other than an exact
Any help would be much appreciated to this newbie (myself)
please email me as it is very easy to miss postings.
Dim sqltxt As String
Dim db As Database
Set db = OpenDatabase("D:\vb5\bt1\vispro41.mdb")
sqltxt = "SELECT * FROM [client details] WHERE lastname LIKE '" &
txtfind & "';"
datPrimaryRS.RecordSource = sqltxt