troubleshooting Question

Access Form Extract a table value based on form field

Avatar of jbakestull
jbakestull asked on
Microsoft Access
2 Comments1 Solution418 ViewsLast Modified:
I"m just having a hard time trying to extract a value from a table via SQL.  

cbotest is a combo box field located on frmUSHS.

After the updated event if the client (intCSPIdentifier from tblVulnerabilityIndex = cbotest) and has a score (intTotalScore from tblVulnerabilityIndex), I would to populate the results on a text field call in USHS from called "txtVulscore".

Any help would be grateful. My head is starting to hurt trying to find a syntax sample that I can use.

Thanks


Table
tblVulnerabilityIndex
intCSPIdentifier
intTotalScore

Form
frmUSHS
cbotest
txtVulscore


Dim rs As Recordset
    Dim strSQL As String
    strSQL = “select [intTotalScore] from tblVulnerabilityIndex where intCSPIdentifier=' & Me.cbotest & "    Set rs = CurrentDb.OpenRecordset(strSQL)
    If Not rs.EOF Then
     
    End If
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 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 1 Answer and 2 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