Hi Geoff,

The table is a flat file.  Each record stores data about a tenant.
There is no repetitive data.

What I am trying to do is a batch update based on data already stored
for each tenant.  For example, each tenant in the database is paying
their rent by direct debit.  What I need to do is produce a form
allowing the user to enter up to 25 tenancy reference numbers.  When
each Ten ref no is entered the unbound text box next to it displays
the current direct debit payment.  In the third column the user needs
to be able to type in a new direct debit amount for that tenant and so
on down the list.  There will probably be a different amount for each
tenant.

I need an efficient way (hopefully without duplicating code for each
Ten ref no – on lost focus event) that isn't to complex to be able to
replace each old direct debit value with the new direct debit value
entered by the user in one go – preferably at the click of a button.
But I also want these 3 pieces of information appended to a new table
with the current date so that letters can be sent to each of the
tenants informing them of what their new direct debit payment is.

Hope this make more sense.

Cheers.