INSERT INTO Buchungen ( BuchungsNr, ..... ) SELECT (" & NeueBuchNummer & ") AS _
  Ausdr1, .....(" & RBNetto & ") AS Ausdr12, .....FROM Buchungen WHERE ((( _
  Buchungen.BuchungsNr) LIKE " & Text1.Text & "))

INSERT INTO Buchungen ( BuchungsNr, ..... ) SELECT (2411251) AS Ausdr1, .....( _
  -431,03) AS Ausdr12, ..... FROM Buchungen WHERE (((Buchungen.BuchungsNr) LIKE _
  2411235))

Frank