Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Atlanta, GA
    Posts
    92

    Unanswered: "Simple" :( Filter only filters exact text

    Simply, when I use this here, I get a working filter. But I need to know the exact spelling of the Company name. How do I make it to where I can type in "Compa" instead of "Company" for a search?

    *****************************
    Private Sub Command58_Click()
    On Error GoTo Err_Command58_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmCompanyInfo"

    stLinkCriteria = "[strCity]=" & "'" & Me![Text56] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Exit_Command58_Click:
    Exit Sub

    ****************************

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    stLinkCriteria = "[strCity] LIKE " & "'*" & Me![Text56] & "*'"
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2003
    Location
    Atlanta, GA
    Posts
    92
    Thanks Teddy,
    My biggest mistake I see is that when I was trying, I was removing the ' and replacing it with the *, instead of adding it. The help is truly appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •