Jarryd,

I suppose this realtes to a previous thread of yours, which was started
in this NG, thus your coming back here... although formscoding would
have been more appropriate for the subject. Anyway, here goes:

As far as the header goes, you only need to add one record, so a plain
append query in VBA, reading directly from the form controls, would be
just fine.

Now, for the line items in the subform, you need some means of storing
them somewhere temporarily, until you are ready to save the header and
thus acquire the order number which is necessary for storing the line
items. An easy way to do it is to use a temporary table with all the
fields in your line items table except for the order number; the subform
must now be bound to this table. Once the code for saving runs and the
order number is calculated, you can then run a second append query in
VBA to store the item records iin the main order items table, and
finally a delete query on the temp table to clear it. Apparently, no
recordset operation required.

To implement the above in code, your code would look something like:

Private Sub cmdSave_Click()
Dim vCust, vDate, vOrderNo, vProductID, vQuantity

'Append header section
vCust = Me.CustomerID
vDate = Me.ReqDeliveryDate
vOrderNo = DMax("OrderNo", "Orders") + 1
strSQL = "INSERT INTO Orders (OrderNo, CustomerID, DelDate)" _
    & " SELECT " & vOrderNo & ", " & vCust & ", " & vDate
CurrentDb.Execute

'Append items section
strSQL = "INSERT INTO OrderDetails (OrderNo, ProductID, Quantity)" _
    & " SELECT " & vOrderNo & ", " ProductID, Quantity" _
    & " FROM TempOrderDetails"
CurrentDb.Execute

'Clear TempOrderDetails section
strSQL = "DELETE * FROM TempOrderDetails"
CurrentDb.Execute

'Clear Form
Me.OrderDetailsSubform.Requery
Me.CustomerID = Null
Me.ReqDeliveryDate = Null

End Sub

Of course, this sample code is not intended to run as is, it is just an
example that will need adaptation to your actual objects (subform name,
number and names of objects on both form and subform, number and names
of tables and fields in them). I hope my choice of example names is
self-explanatory, so you get the idea.

HTH,
Nikos