Thanks ByteMyzer, I did find a solution similar to the one you suggested, like so:
rcd.Open "tmpTables", cn, adOpenKeyset, adLockOptimistic, adCmdTable
....
With rcd
.AddNew
!TableType = txtType
!AccountNumber = Mid(inline, 7, 16)
!ReturnDigit = Mid(inline, 23, 10)...