Howdy, Stranger!

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

Categories

Stlinkcriteria with wildcards

Harry PalmerHarry Palmer Member Posts: 1
Hello

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.