(Solved) – I have a syntax error with Acess VBA insert into

  • by
(solved)-–-i-have-a-syntax-error-with-acess-vba-insert-into
step2 = "INSERT INTO Products" & _
            "(ProductID, ProductName,UnitPrice)'"
step2 = AddValue(step2, Text7) & "', '"
step2 = AddValue(step2, Text15) & "', '"
step2 = AddValue(step2, Text9) & "' FROM Products"

Private Function AddValue(qry As String, txtbox As TextBox) As String

txtbox.SetFocus
AddValue = qry & txtbox.Text  

Leave a Reply

Your email address will not be published. Required fields are marked *