Is there a way on a subform to populate a field from a field in its parent form.  I am creating a database for my trucking business.  Each load I haul is in its own table.  I haul for numerous different customers(own table). Also Numerous different Products(Own Table) for different rates.  I have everything setup to pull all my unpaid loads for different customers into fields on a form, this gets populated through a query.  I want to make a form for an invoice and put my unpaid loads into that form as a subform(the gets its info from a query).  Then have the invoice number in the parent form get autopopulated back to each load number on the child form on that invoice.  I was thinking of making a field in the table that holds all of my load information that holds my invoice number.  How do I make the autonumber in the invoice automatically get filled in the Invoice# in the LoadT?