I think I figured it out with a little reading. I'm a noob (of course), but found that an Append Query is the direction to go. Here is my append query:

INSERT INTO Samples ( SampleLotID, LocationID, BoxID, BoxSlot, Quantity, UOMID, SampleContainer Number )
SELECT SampleLots.Samp leLotID, Forms!SampleLot s!SL_Location AS Expr3, Forms!SampleLot s!SL_Box AS Expr5, Forms!SampleLot s!SL_BTcnt AS Expr2, Forms!SampleLot s!SL_Quantity AS...

Does anyone have a basic example of a script that can automatically fill fields in a subform? Here is the scenario:

I have a main form for a Sample Lot and I have added some side-fields (not bound to any table) that asks basic information: Number of Samples (x), Quantity, Unit of Measure, Location, Tray...I would then like a button that triggers a script to automatically create the Sample Details (subform) that is autonumbered and...