Forms :: Recordset Viewing / Editing In Forms

I am trying to create a (normally simple) application, but not having a solid grasp on the concepts of recordsets. The application is serial number tracking for appliances.

The functionality needs to be able to:Search for serial numbers using partial strings (i.e. serial # "T12395723K39" can be located by entering "3K3")

If the serial number does not already exist, allow for adding it.
If data was added erroneously, allow editing to correct it.

The first 2 points are complete but I am struggling with the last. After a user performs a search, I store the results of that search to a temporary table for easy viewing of applicable records.

To allow someone to edit, they simply double click on one of those records to open a seperate form and edit.

When I displayed the content of the temporary table in the form for editing, I found it was not updating the original table.

When I create a separate recordset, using the values of the record selected, the recordset appears to be empty, therefore not displaying the correct record for editing.

My main table name is "SerialNumbers". The code below is triggered when the user double clicks on the desired record to edit.

Private Sub Claim_DblClick(Cancel As Integer)
'************************************************* ********************
'* Subroutine to take values from search results for editing record. *
'************************************************* ********************
'Initializing variables
Dim ClaimNo, ApplianceName, SerialNo, MakeName, ModelNo, sqlstr As String

[Code] .....