You really need to be a lot more specific when giving examples and asking questions. Remember, we can't see your dB (unless it is still the "Hurricane_Mesa_Parts_Inventory - VC"?)
It is like you giving me directions by telling me to turn left, then take 2 rights and a left - but I don't know where to start from or the street names.
Here is an example of an append query (in code) to insert a record into a table ("tblAuditTrail") where the form is bound to table "InventoryTable"
Code:
Private Sub Consume_Click()
Dim sSQL As String
sSQL = "INSERT INTO tblAuditTrail ( C_Part Number], C_Program, C_Lot Number] )"
sSQL = sSQL & " VALUES ( " & Me.[Part Number] & ", " & Me.[Program] & ", " & Me.[Lot Number] & ")"
CurrentDb.Execute sSQL, dbFailOnError
Error_Handler_Exit:
On Error Resume Next
Exit Sub
Error_Handler:
MsgBox "Cannot have Qty < 0"
Resume Error_Handler_Exit
End Sub
So it is important to know WHERE the values you want to insert come from, the name of the table you want to add the record to and the names of the fields in that table.
If you feel you can't post the dB, maybe an image of the relationship window or an image of the table to get the field names......