dlookup syntax error 1

[ProgramError]

Hi All

Anyone know how to change this to look for the input if it is only part of the data enter in the field
eg if hello is entered then it should return billyhellothere
aswell as just hello

strSearchCriteria = Nz(DLookup("modelID", "tblmodel", "model = '" & Me.txtSearchDetails & "'"))

i tried

strSearchCriteria = Nz(DLookup("modelID", "tblmodel", "model = *'" & Me.txtSearchDetails & "'*"))

but got a
syntax error in query expression 'model = *'hello'*'

any ideas?
Thanks


Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[Remou]

Your idea is correct, but the positioning is off:

[tt]strSearchCriteria = Nz(DLookup("modelID", "tblmodel", "model = '*" & Me.txtSearchDetails & "*'"))[/tt]

 

[PHV]

Use the like operator:

strSearchCriteria = Nz(DLookup("modelID", "tblmodel", "model Like '*" & Me!txtSearchDetails & "*'"), "")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ProgramError]

Thank you both.

Remou, the amendment you suggested did not completely work, it returned no values. It was the addition of the 'like' comparator as suggested by PHV which did job.



Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.