Excel Macro export data to specific Access Record

[redbenn]

Hello,
I am trying to create an excel macro, that when clicked... a specific cell will match a record in my database, and update certain fields in this record.

The Excel file will have a cell that is the same as a 'Tracking Number' (the primary key) of my Access Table. The output from excel would access this record and update the field.

I currently have a macro to create new records in the table, but I am not sure if there is a way to update certain records.

Thanks,
Adam

[redbenn]

here is the code i have currently to add a new record:

Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
    ' connect to the Access database
    Set cn = New ADODB.Connection
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
        "Data Source=c:\db1.mdb;"
    ' open a recordset
    Set rs = New ADODB.Recordset
    rs.Open "ProjectInbound", cn, adOpenKeyset, adLockOptimistic, adCmdTable
    ' all records in a table
 With rs
            .AddNew ' create a new record
            ' add values to each field in the record
 
            .Fields("Output") = Range("C10").Value
 
            ' add more fields if necessary...
            .Update ' stores the new record
 End With
 
 With Application
        .ScreenUpdating = False
        .DisplayAlerts = False
    End With
 

[redbenn]

I found this clause in some other code, which may be what I am looking for, but I cannot figure out the context

.Open "select * from c_test where c_testid = '" & labelID.Caption & "'"

[redbenn]

I also found this bit of code

rs.Find("Tracking Number=" & Range("A1").Value)
 

but I get this error:
"arguments are of the wrong type..."