Access Loop a datamacro in Access 2010 using vba code

[Sunigahj]

I would like select specific items from a table then using recordset loop and a datamacro to create new records on a orderdetail table with the main tableID and orderdetail table ID. This is my first post so If I didn't do this correctly please let me know.