Soft search using Like or the equivalent 1

[daybase]

Help - I am having a mental block - I have an input form where I can define search criteria and all works fine but I want to make the search a little more flexible so that I can search for parts of names - equivalent to like "*" & [enter detail] & "*" in a query. Assistance please. Current code is

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "detaildata"

stLinkCriteria = "[nwthename]=" & "'" & Me![whichclient] & "'"

DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[TheAceMan1]

How are ya daybase . . .

A starting point:

[blue]stLinkCriteria = "[nwthename]=" & "'[purple][b]*[/b][/purple]" & Me![whichclient] & "[purple][b]*[/b][/purple]'"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[daybase]

Many thanks - I had just had a lucid moment and got the answer myself but, as ever, thanks for the assistance.