Yea you could just add to the statement or make another one if it's a different table. Or use a recordset.

Thanks Adam, it doesn't work with both the two statements together. Either Statement works if you remove the other though, but the code for the SubF doesn't link the ID from the mainform to the detail ID

If the form is unbound you will need to include all the fields in the insert statement. SAPID isn't included in the statement for your subform.

Thanks Kevin, Yeah that doesn't seem to make a difference. With both sets of code DBExecute is only working for the main form. If i take out the code for the main form the second DB Execute works but is missing the SAPID - Which i have now included in the code. I'm not sure even that the SubForm is unbound.  Record Source for the SubF is a query (not complicated). The Mainform has unbound controls but the record source is a table. The add button creates the SAPID on the click. Looking at the properties the subform is linked by SAPID / SAPID but the main form does not have a SAPID bound control if that matters.

Marc - -
The basic problem you have here is that you are bypassing your form / subform relationship with your add button code.  The subform is not "self-aware" - it doesn't know where to get the SAPID from because you added in a record via code in the background.
I'm pretty sure you can add in the main record and the line items just fine if you do it manually - correct?

So, what needs to happen, when you execute the first INSERT you need to capture the ID that was just created by the Autonumber and then that ID needs to be passed into your second SQL INSERT for the relationship to be made.

I see that you have Developer 24.  Go watch that again to see 2 different methods for copying an order and details.  That should help you out in solving your problem.

I wouldn't think that second one would work at all. Those fields are on the subform, should have to give the full name Forms!ParentFormName!SubFormName.Form!FieldName

Thanks Scott and Adam, Yeah i can add to the tables when the mainform has bound fields. I've taken a look at developer 24 but i haven't been successful with either 2 approaches. The problem is im not actually copying anything that is already committed to the table. That is what i am trying to get the form to do. What i have managed to do with the code is get an ID in both forms but strangely its creating a ID that already exists.  The subform is where you select orders details from a detail table and the mainform is the order form. Very similar to the orderform created in the lessons. What i have noticed the add button on the Sub commits the subform data right now. So i can get it to do either but not link the two together. My ultimate goal here is to have a choice on the mainform by either select a record that already exists using a combo and add the details to that ID or have it create a new ID and add the details to the new ID.