If I hard code search criteria i.e.
adodc1.recordset.find "car Like 'corvete'"
will work. But if i try to use an entered sting
in text box on a form and assign it to a string
variable with wildcards in the "find" it does not work.
Dim test As String
test = text6.Text
Adodc1.Recordset.Find "[car] LIKE '" & test & "'" 'Works
'hard coded not using info entered from text box
Adodc1.Recordset.Find "[car] LIKE 'Corvette'" 'WORKS
Adodc1.Recordset.Find "[car] LIKE 'test*'" 'DOES NOT WORK
I want them to enter which car is their preference but not have
to enter the full name hence the need for the wildcard. The problem
seems to arise when looking for an incomplete string entered in a text
boxe on a form to a comparable record using wildcard "*" .
Anyone have the answer or a workaround solution? Thanks