Combined WhereCondition Using Access2007

[emari2]

I need a complex query from a table
The first part alone works well

    Dim fechainicial As Date
    Dim stDocName As String
    Dim stLinkCriteria As String
fechainicial = Text207
fechafinal = Text209
    stDocName = "Incidenciasenlabasededatos"
    stLinkCriteria = "[Fecha]>=#" & fechainicial & "#" & " And " & "[Fecha]<=#" & fechafinal & "#"
 
    DoCmd.OpenForm stDocName, , , stLinkCriteria

The second alone works well

 If Texto167 = "Técnica" Then
 
    stLinkCriteria = "[Tipo de incidencia]='Técnica'"
 
    End If

but if I joint the two, does not work and I have I sintax error

 stLinkCriteria = stLinkCriteria & " And " & "[Tipo de incidencia]='Técnica'"
or
 
 stLinkCriteria = stLinkCriteria & " Where " & "[Tipo de incidencia]='Técnica'"
    MsgBox (stLinkCriteria)

Note.- in this case stLinkCriteria is the first one of course
I am missing something in the sintax . Can you help? Thanks

[RuralGuy]

You do *not* use the word "WHERE" in a WhereCondition argument! Just use another AND.

[emari2]

You do *not* use the word "WHERE" in a WhereCondition argument! Just use another AND.

I already use another AND and something is wrong with the sintax as it gives me an error

[Stewart Ross]

Hi. It seems to me that you've not thought through what will happen if the IF statement does not match the contents of Texto167. Since stLinkCriteria will be left as an empty string, the value of stLinkCriteria will then just become

stLinkCriteria = <empty string> & <your new criteria> 
=>
" AND [Tipo de incidencia]='Técnica'"

which is bound to generate an error.

Simplest solution is to move the AND to the end of the part within the IF:

stLinkCriteria = "[Tipo de incidencia]='Técnica' AND "

-Stewart