Makes sense thanks! I've actually been testing since i posted & found a simpler way of achieving this that won't require me to add/update 12 columns to both tables for the VBA - however this wouldn't of been possible without your earlier work so thanks again!

 rs(fieldnumber) = "Invoice " & count2 & " of " & count
Where count2 is the current installment number being processed and count is the number of installments

Tom