I have a form that allows users to change data, I log the change with this code: -
Sql = "INSERT INTO ChangeAudit ( OrderNo, OrderLine, Barcode, PreQty, ProgType, [DateTime] ) "
Sql = Sql & "SELECT OrderDetail.OrderNo, OrderDetail.OrderLine, OrderDetail.Barcode, OrderDetail.QtyOrdered, 'OrderOut' AS Ord, Now() AS DTime "
Sql = Sql & "FROM OrderDetail "
Sql = Sql & "WHERE OrderDetail.OrderNo = " & CInt(Me![CboOrder]) & " AND OrderDetail.OrderLine=" & CInt(Me![CboSelectLine]) & ""
The change quantity is on the form as me!Qty, how do I add this to my audit table (ChangeQty field already exists)