Hi I have a form that requires the user to enter a tenancy reference
number in the first column, and when this is done it brings back their
direct debit payment for their rent in the second column (It uses SQl
to bring back the amount when the Tenancy Reference No loses the
focus). In a third column I want the user to type in the value for
the new rent amount. This may be for one tenancy record up to 25 in
one go, for example:
Tenancy Reference No Old Payment New Payment
-------------------- ----------- -----------
|123456789 | |30.00 | |37.00 |
-------------------- ----------- -----------
-------------------- ----------- -----------
|987654321 | |20.00 | |24.00 |
-------------------- ----------- -----------
-------------------- ----------- -----------
|121212121 | |65.00 | |54.00 |
-------------------- ----------- -----------
Now my form has provision for 25 Tenancy Reference Numbers and old
payments to be entered (25 unbound text boxes for each). I have
started to do work through this and am finding that I am repeating the
same code over and over for each. I am also at a loss as to how I can
update each old figure with the newly entered one. I want the whole
lot to update when a button on the form is pressed.
As well as updating the old values with the new ones, I would like to
copy the tenancy reference numbers, old values and new values along
with the current days date to a new table so that letters can be
created for those tenants amended so they can be notified of the new
rent amount.
Could someone please put me on the right track as to the best way of
doing this. I started reading some info on Arrays but can't see how
to use them with what I'm trying to do.
Can anyone point me to an example in a demo database or FAQ website
for Access?
The simpler the recommended solution, the better. Thanks in advance
for any suggestions.
Regards.