I am not sure how you are implenting this. You just pass the field as parameters to the query behind your results form or report. Like this:
'-----
Dim stSearchValue As String
Dim stLink As String
Dim stDocName As String
stSearchValue = Me.TextFieldValue
stLink = "[SearchField] = Like " & "'" & stSearchValue & "'" & "*"
stDocName = YourFormOrReportName
DoCmd.Open(Form or Report) stDocName, , stLink
'-----
You may have to play with the syntax a little for the wildcard. This assumes the search value is at the beginning of the string. It can be in the middle or at the end. I have done this but don't have time to find it right now. Let me know if you still need help on this, or another poster can jump in.
HTH
mmcdonal
|