I am trying to develop a "new invoice form" that will pull up previous invoices as reference and allow modification. I am using VBA .addnew code to write the new invoice data into the table but am struggling with the best way to pre populate the fields (and thus minimize the need to change data if majority of the bill/field are the same time after time). When I pull previous information via query to the form, any edits actually change the prior data. I really just want to load the values but not have dynamically linked. thanks