stLinkCriteria and wildcards?

[Jen]

This stLinkCriteria works ok, that is, it returnes the exakt matches from
the "txt_bladdra_per_fritext" textbox

stLinkCriteria = "forklaring =
[Forms]![startform]![txt_bladdra_per_fritext]"

However, this of course returns only exact matches. How do I make this so
that it finds matches that is similar to the parameter I wrote in the
"txt_bladdra_per_fritext" textbox? No matter if the word I'm looking for is
in the middle of a sentence or starts with a capital letter and I write the
word in small letters and so on?
I have fiddled with wildcards like &"*", used the "Like" word but without
getting this to work.

Jen.

 

[Gary Miller]

Jen,

See if this works....

stLinkCriteria = "forklaring Like '*" &
[Forms]![startform]![txt_bladdra_per_fritext] & "*'"

Gary Miller

 

[Jen]

Works perfectly. Thank you so much Gary!

Jen.

Jen,

See if this works....

stLinkCriteria = "forklaring Like '*" &
[Forms]![startform]![txt_bladdra_per_fritext] & "*'"

Gary Miller

This stLinkCriteria works ok, that is, it returnes the exakt matches from
the "txt_bladdra_per_fritext" textbox

stLinkCriteria = "forklaring =
[Forms]![startform]![txt_bladdra_per_fritext]"

However, this of course returns only exact matches. How do I make this so
that it finds matches that is similar to the parameter I wrote in the
"txt_bladdra_per_fritext" textbox? No matter if the word I'm looking for is
in the middle of a sentence or starts with a capital letter and I write the
word in small letters and so on?
I have fiddled with wildcards like &"*", used the "Like" word but without
getting this to work.

Jen.