Type mismatch error 1

[fdalmoro]

I get a type mismatch when I implemented this code;

stLinkCriteria = "[TECH_ASSIGNED]=" & "'" & Me![OPEN_WO_LIST] & "'" And "[STATUS]=" & "'" & "Pending" Or "[STATUS]=" & "'" & "In Progress"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

What this is doing is that there is a list box on the form displaying the names of certain Technicians. When you click on any of the names, it pulls up in another form only the WO calls that have their names in it. I think the problem is somewhere in the stLinkCriteria after the And because that's the part that I recently changed. I'm not sure if that's the way to tell it to only display the rows that have "Pending" or "In Progress" in the Status field.

thanks

 

[GHolden]

You may find this works...

stLinkCriteria = "[TECH_ASSIGNED]= '" & Me![OPEN_WO_LIST] & "' And ([STATUS]='Pending' Or [STATUS]= 'In Progress')"


There are two ways to write error-free programs; only the third one works.

 

[fdalmoro]

Thanks