link Criteria when opening forms

[4321z]

This is probaly really easy but i can't suss it, i'm trying to open a form using the link criteria and i don't want a specific value i want similar values, here's the link i'm trying:

stLinkCriteria = "[Address] '" Like " ''*" & strInputSearchWord & "*'"

but it doesn't like it much, any ideas?

 

[p27br]

try
stLinkCriteria = "[Address] Like '*" & strInputSearchWord & "*'"

 

[4321z]

this doesn't seem to work either

stLinkCriteria = "[Address] Like '*" & strInputSearchWord & "*'"

i just get everything, the strInputSearchWord variable is coming from an input box

 

[p27br]

hi I just tried it out : I have a form with a command button, on the on click event of this form, I have this code :
DoCmd.OpenForm "frm", acNormal, , "[spec] like '*" & InputBox("speciality&quot & "*'"
and it opens another form that is filtered on the criteria.

can you explain more in detail how you are proceeding ?

 

[4321z]

yeh here's the whole code

Dim stDocName As String
Dim stLinkCriteria As String
Dim strInputSearchWord As String

strInputSearchWord = InputBox("Please Enter Your Search Word", "Master Database", "*&quot
If Len(strInputSearchWord) <= 0 Then
Exit Sub
End If

stDocName = &quot;HelpFindAddressOuter&quot;
stLinkCriteria = &quot;[Address] Like '*&quot; & strInputSearchWord & &quot;*'&quot;
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly

 

[p27br]

hi

I copy/pasted you code and it works fine !
have you opened the form in design mode then have a look at the DATA properties : FILTER. It should contain the characters you entered.