Main form and Sub form to create records on two tables

[Grahamiwa]

I am trying to create an Inventory and sales database.
I have loosly used the Microsoft Northwind template as a guide.
I have a Sales form with a Sales Detail sub form.


The sales form creates a new record on the sales table (Fields - Sale ID, Customer ID, Sales Date) and the sub form creates a new record on the Sales Detail table (Fields - Sales Detail ID, Sale ID, Product ID, Quantity, Unit Price).

I also need the Sales Date, Product ID and Quantity entered in the Inventory Transaction Table (Fields - Inventory Transaction ID, Transaction Date, Transaction Type ID, Product ID, Quantity).

I can set the default value for the Transaction Type ID to that required for a sale in the Inventory Transaction Table but I don't know how to get the other data into the table.

[ranman256]

Once you enter data into the tables, you need a 'save' button that would acually write the transaction.
Prevent the user from leaving the screen until this button is clicked and runs the append query to the tTransaction table , and close the form.
Maybe an invisible checkbox that indicates if the query was run.

user clicks SAVE
runs the transaction query
marks the chkSaved = true
then close the form.

If user tries to close form with chkSaved = false, it stays open

Private Sub Form_Unload(Cancel As Integer)
  if  chkSaved.value = false then msgbox "You must SAVE the data"
   cancel = chkSaved.value = false
End Sub