Opening Form Based on Mutiple Combo box values

  • Thread starter Thread starter Jamie
  • Start date Start date
J

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
 
Your error is in the Criteria.Try this:

stLinkCriteria = "[Technician Username]='" & Me!
[Combo13] & "' AND [Priority]='" & Me![Combo16] & "'"
 
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
.
Click to expand...
.
Click to expand...
 
Back
Top