Private Sub cmdSendOrder_Click() 'add data to table CurrentDb.Execute "INSERT INTO OrderSummary(OrderNumber, SupplierCode, DateOrdered, EmployeeNumber) " & _ " VALUES (" & Me.txtOrderNumber & "','" & Me.cboSupplierCodeO & "','" & Me.txtDateO & "','" & Me.txtEmployeeO & "') " 'refresh data on list of form OrderSummarySub.Form.Requery End Sub
My code gets a run-time error saying it has a syntax error (missing operator) in certain query expressions. I'm pretty sure the names i put above were correct. so sorry, struggling with ms-access here. newbie here.