[resolved] searching in access tables

[brellis1]

I know this should be easyb tu I just can't seem to get it right. I am trying to take information from one table and update another table with it, what is getting me is the seek function, or how to pinpoint the location of entry to be update.

Dim db As Database
Dim WellInfo As Recordset, PluggedInputTable As Recordset
Dim currentWell As String, SQLt As String
Set db = CurrentDb
Set WellInfo = db.OpenRecordset("WellInfo")
SQLt = "SELECT * FROM PLUGGEDINPUTTABLE ORDER BY PLUGGEDINPUTTABLE!WellId;"
Set PluggedInputTable = db.OpenRecordset(SQLt)
PluggedInputTable.MoveFirst
Do Until PluggedInputTable.EOF
    currentWell = PluggedInputTable!WellID
    
   varbookmark = .Bookmark
   ' WellInfo.Find (WellID = currentWell)