Syntax fejl i stLinkCriteria = \"\"

Not quit sure what your problem is but I would think it should be

"\"Kunder\""

I would use myself
stDocName = """Kunder"""

if th ename of your table is "kunde"
But you should NOT use " a spart of the name!

Copy terry.

I have now changed the code a bit using """ instead of \" and then used CreateForm setting its filter property equal to stLinkCriteria.
However when creating the form it seems like the filter property is changed doing some kind of wizard process!

  For Each fld In tdf.Fields
         
        If fld.Type = dbText Then
            If fld1 Then
                stLinkCriteria = stLinkCriteria & """ [""" & fld.Name & """] Like \'*""" & Me.sFind & """*\'"""
                fld1 = False
            Else
                stLinkCriteria = stLinkCriteria & """ OR [""" & fld.Name & """] Like \'*""" & Me.sFind & """*\'"""
            End If
           
        End If
       
        Next fld

Filter property on the form after CreateForm:

"\"" ["sName"] Like \'*"O2"*\'"" OR ["sID"] Like \'*"O2"*\'"" OR ["sSynonyms"] Like \'*"O2"*\'"" OR ["sIdentificationOther"] Like \'*"O2"*\'"" OR ["sEmpiricalFormular"] Like \'*"O2"*\'"" OR ["sChemicalClass"] Like \'*"O2"*\'"" OR ["sCompoundUsedParenterals"] Like \'*"O2"*\'"

There is too many \ and "" in this property for me to decide if the code is correct but I had only expected to find one record where sEmpiricalFormular Like "*O2*" - now I shows all records!

Too many for me too :o(

Are ALL you field names "fldName" like this?
As you can see it is just causing problems and IS bad practice!

What do you mean terry?

der er så mange ""\\ at det er MEGET svært at se hvad der er der er galt!

You should try to use only A to Z 0 to 9 ánd maybe _ for table and field names. Using 2 in the name is ONLY going to give problems!

thanks malm, hope you got it working!