I just did a mockup to see how the SQL was being rendered using debug.print and some local variables.
Code:
Sub tryInsertSyntax()
Dim strrecordsql As String
Dim empval As String: empval = "EmpVal"
Dim upc As String: upc = "12345HF"
Dim orderno As String: orderno = "abcdefG"
Dim dt As Date: dt = #2/23/2019#
'strrecordsql = "INSERT INTO WOTracking (Employee, UPC, OrderNo, DateTime) VALUES ('" & Me.cbxEmployee.Value & "','" & Me.tbxProductUPC.Value & "','" & Me.tbxOrderNo.Value & "',#" & dtDateTime & "#)"
strrecordsql = "INSERT INTO WOTracking (Employee, UPC, OrderNo, DateTime) VALUES ('" & empval & "','" & upc & "','" & orderno & "',#" & dt & "#)"
Debug.Print strrecordsql
'CurrentDb.Execute strrecordsql
End Sub
Gives this
Code:
INSERT INTO WOTracking (Employee, UPC, OrderNo, DateTime) VALUES ('EmpVal','12345HF','abcdefG',#23-Feb-19#)
which looks OK to me if all are short text except date (which is dateTime)
(23-Feb-19) is because of my regional setting