Find record help

[lydz]

hi, im making a search, got exact to work using this

Case "Dewey Decimal"
DoCmd.ShowAllRecords
DoCmd.GoToControl ("Dewey Decimal")
DoCmd.FindRecord Me.txtCriteria

tried to do one using like, like this

Case "Title"
DoCmd.ShowAllRecords
DoCmd.GoToControl ("Title")
strResult = [Title] Like "'*" & Criteria & "*'"
DoCmd.FindRecord strResult
Me.txtcrit = strResult

but it doesnt work, set up the text box crit, just to see what result was coming out as and it says false
does anyone know whats going wrong or how you can use the like operator with the findrecord function?
thanks

 

[boblarson]

strResult = "[Title] Like '*" & Criteria & "*'"

 

[lydz]

thanks, but it still doesnt work
but now the text box thats based on strResult = [Title] Like '*hat*'
hat being what i searched
i have a title called 'enigma of the hat' so it should have pointed to that

 

[lydz]

acAnywhere did it
the pointer points to the record, looking to move to the top