Search Engine issue

[diego Munoz]

Hello everyone I have a problem in my database that I’ am trying to create. I’m made a search engine/input form database. I have a Table called Tbl_Main and in this table there are some fields name (Location1, Quantity and Reference Number). Next I have a form called Frm_SearchEngine with an unbound text field called Txt_ScanLoc and a button. This is what I have in my button

Private Sub Command21_Click()
   If IsNull(Me.Txt_ScanLoc) = False Then
    Me.Recordset.FindFirst "[Location1]='" & Me.Txt_ScanLoc & "'" 
           If Me.Recordset.NoMatch Then
        MsgBox "No record found", vbOKOnly + vbInformation, "Sorry"
            Me!Txt_ScanLoc = Null
            Else
             DoCmd.OpenForm "Frm_Physical Inventory Window"
      End If
   End If
End Sub

This works fine. My problem is when the second form opens up which is called frm_Physical inventory Window and it contains three bound text fields called (txt_Location1, Txt_Quantity, and Txt_Reference Number) I want the information I put in my first form text field example (D49-10A-001) to my txt_Location1 field. I try to do an on load event with this code Me.Txt_Location1 = Forms!Frm_SearchEngine.Txt_ScanLoc.Value it works but when I add information to my quantity and reference fields it updates the first record on my txt_main table and not to the corresponding location. Any idea what I m doing wrong?

Thanks everyone for you help