Append Statement Help

i'm using the Microsoft Access XP template "order entry", i have populated the product table with products. and i wrote an append statement.


INSERT INTO [Order Details] ( ProductID, OrderID )
SELECT Products.ProductID, Orders.OrderID
FROM Products, Orders
WHERE (((Orders.OrderID)=[Forms]![Orders by Customer subform]![OrderID]));


(i need the where clause the pull the OrderID from the Order by Customer Subform, i hope i did that correctly, someone please let me know)

On the Order Details subform, i'm trying to get it to display all the products at once.

Is there any way to get this SQL statement to execute after the form loads and refresh the output on the subform? Or is there any other way i could do this

I'm thinking we might have to do this in VBA, not sure

Let me know, Thanks