vba - MS Access 2010 Form Data Entry- Adding the Same Field to Multiple Entries -

i created table keep track of shipments , invoices associated them. i'd prefer table set below can draw relations off of invoice number column.

shipment table `````````````` field name      |   data type ----------------+------------- id              |   autonumber or concat ship date       |   date shipper         |   list lookup invoice number  |   text 

often times there multiple invoices on 1 shipment id, in form need id, ship date, , shipper fields input multiple invoice number records.

i'm not handy vba, , macro builder doesn't seem able want without going vba anyways. how tackle using vba?

sample data ```````````  id     |  ship date   | shipper | invoice number -------+--------------+---------+----------------- 13597  |  5/15/2015   |  ups    |   230136 13597  |  5/15/2015   |  ups    |   230137 13597  |  5/15/2015   |  ups    |   230138 

form design: http://i.stack.imgur.com/vyjlf.jpg