Dim SQL2 As String
Dim Skl As String

SQL2 = "SELECT * FROM tblTransakcije IN 'D:\Sve_Godine\Baze\Prodaja_2016_be.mdb'"

Tablica = "QryStanje"
Tablica_2 = "tblUlazIzlaz"

Set SL_Pocetna = Db.OpenRecordset(Tablica, dbOpenDynaset)
Set SL_Zavrsna = NovaDb.OpenRecordset(Tablica_2, dbOpenDynaset)

If SL_Pocetna.RecordCount > 0 Then
        SL_Pocetna.MoveFirst
        While Not SL_Pocetna.EOF
            With SL_Zavrsna
            .AddNew
      
            Skl = SL_Pocetna!Skladiste
                
                ![IDTransakcije] = DLookup(SQL2, "Skladiste = '" & Skl & "'")
                !Sifra = SL_Pocetna!Sifra
                !Ulaz = SL_Pocetna!Stanje
                !Izlaz = 0

            .Update
        End With
         SL_Pocetna.MoveNext
        Wend
   End If