Linking to subform with wildcard

[dewsbury]

Greetings From Ireland !

I am joining two forms successfully (matching on names) and the wizard generated the code below.

stLinkCriteria = "[surname]=" & Me![surname]


However,I want to match using wildcards. E.g. "smi*" should match to "smith".

How do I amend the syntax of the code above.

I would appreciate the precise syntax as I have struggled with various versions of my own.

Thank you!

(also on utteraccess.com)

 

[John Big Booty]

Could you explain in a little more detail just what you are trying to achieve.