Stlinkcriteria with wildcards


If anyone can help it will be great.

I am trying to use the stlinkcriteria to open a form a based on what is entered in a textbox. The situation is complicated by the field being a memo with lists of phone numbers. I can insert a wildcard at the end of the number but not at the start is this possible?

Currently the code is

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Company Records"

stLinkCriteria = "[Analogue Nos]like '" & Me![Text102] & "*'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!