Opening Form Based on Mutiple Combo box values

[Jamie]

I am trying to open a form that displays the results of
mutiple combo boxes values, however it keeps coming up
with 'Type Mismatch' does anybody know why?

Dim stLinkCriteria As String

stDocName = "Closed Jobs1"


stLinkCriteria = "[Technician Username]=" & "'" & Me!
[Combo13] & "'" And "[Priority]=" & "'" & Me![Combo16]
& "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[aj]

Your error is in the Criteria.Try this:

stLinkCriteria = "[Technician Username]='" & Me!
[Combo13] & "' AND [Priority]='" & Me![Combo16] & "'"

 

[Guest]

Thank You

-----Original Message-----
Your error is in the Criteria.Try this:

stLinkCriteria = "[Technician Username]='" & Me!
[Combo13] & "' AND [Priority]='" & Me![Combo16] & "'"

-----Original Message-----
I am trying to open a form that displays the results of
mutiple combo boxes values, however it keeps coming up
with 'Type Mismatch' does anybody know why?

Dim stLinkCriteria As String

stDocName = "Closed Jobs1"


stLinkCriteria = "[Technician Username]=" & "'" & Me!
[Combo13] & "'" And "[Priority]=" & "'" & Me![Combo16]
& "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
.

.