Transfer of Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a data vase which has TABS on a Form to move from 1 area to
another. One is Called Householder1 and another called Householder2, both of
which have details relating to individuals. What I want to do is transfer
details of Householder1 to Householder2 and Householder2 to Householder1
when Householder1 has died. Is there a way of doing this or do i have to
live with cut and paste.

Thanks for any help
 
You could program a button to copy the details of one member to another.

But a better solution might be to set up the database so it can cope with
both persons and households. For an example, see:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html
 
Thanks for that, but how do I program a button to copy details of one member
to another.
Thanks again
 
You will need to write code to identify which are the other member(s) of the
household, copy the fields of one into a set of temporary variables, set the
fields of the other into that one, and then copy the temp variables into the
other.

The details will depend on your data structure. If both people are loaded
into the form, you could use the RecordsetClone of the form to get at the
other record. Otherwise you will need to OpenRecordset().
 
Back
Top