troubleshooting Question

Access 2007 Data type mismatch in criteria expression

Avatar of jbakestull
jbakestull asked on
Microsoft AccessSQL
7 Comments3 Solutions752 ViewsLast Modified:
I'm not sure why I receiving this error.

Highlighted line is: Set rs = CurrentDb.OpenRecordset(strSQL)



Private Sub cbotest_AfterUpdate()
Dim rs As Recordset
Dim strSQL As String

 
strSQL = "select [intTotalScore] from tblVulnerabilityIndex where intCSPIdentifier=" & Me.cbotest & " And [intTotalScore] <> Null"
    Set rs = CurrentDb.OpenRecordset(strSQL)
    If Not rs.EOF Then
        Me.txtVulscore = strSQL
    End If
   
End Sub
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros