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